Ask a question from expert

Ask now

Lodgement Method and Age Group

4 Pages415 Words85 Views
   

Added on  2020-05-16

Lodgement Method and Age Group

   Added on 2020-05-16

BookmarkShareRelated Documents
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:
Lodgement Method and Age Group_1
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.
Lodgement Method and Age Group_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Statistics and Data Analysis Assignment
|5
|1044
|39

BUS708 Statistical Modelling Assignment - DOC
|13
|2594
|72

BUS708, Statistics and Data Analysis | Study
|13
|2166
|214

Chi-Square Test of Association and T-Test for Breastfeeding Duration
|15
|2438
|408

Setting up – Task 0
|5
|962
|407

Pivot Table: A Statistical Tool for Summarizing Data in a Tabular Structure
|4
|422
|88