Lodgement Method: Dataset 1To answer this question, at first a pivot table is inserted in excel by choosing the wholedata as the table range and then selecting lodgement method under rows and values. This resultsin the table 2 in the answer file. Inserting a pivot chart and selecting 3d pie chart gives figure 1.The confidence interval is obtained using the following template:Lodgement Method: Dataset 2 The same procedure is followed as in the last section, only with the second dataset thistime. The template for the confidence interval is also the same. The template to obtain thedifference between the two proportions is given by:
The mentioned cell references of the cells AB is Lodgement Method and Age GroupAgain pivot table has been inserted by selecting the entire table and then keeping agerange as rows and lodgement methods as columns and selecting lodgement method as the values,the table 7 has been obtained. Figure 3 is obtained by inserting pivot chart to the pivot table.
End of preview
Want to access all the pages? Upload your documents or become a member.