Reference no: EM133575660

Question: In order to prepare a reply to Chris's memorandum, you will need to examine and analyse the dataset HealthSurvey.xlsx thoroughly.

Chris has asked a number of questions and your data analysis output (i.e., your charts/tables/graphs) should be structured such that you answer each question on the separate tab/worksheet provided in your Excel document. There are also three extra tabs in HealthSurvey.xlsx called CI, HT and SS and you should use the various templates contained in these tabs in your "Confidence Interval", "Hypothesis" and "Sample Size" answers.

In order to effectively answer the questions, your data analysis output needs to be appropriate. Accordingly, you'll need to establish which of the following techniques are applicable for any given question:

• Summary Measures (e.g., descriptive statistics, Inc. outlier detection, percentiles).

• Comparative Summary Measures (i.e., descriptive statistics, outlier detection and percentiles for multiple values of a variable).MIS770 Foundation Skills in Data Analysis Assignment Two Page 4

• Suitable tables (such as a frequency distribution) and charts or graphics (such as histograms, box plots, pie charts, bar/column charts, polygons) that will illustrate more clearly, other important features of a variable.

• Scatter Diagrams (used to visually establish if there is a relationship between two numeric variables).

• Cross Tabulations (sometimes called contingency tables), used to establish the relationships (dependencies) between two variables (see Additional Materials under Topic 2 - Creating Cross Tabulations in Excel using Pivot Tables).

• Confidence Intervals. You can assume that a 95% confidence level is appropriate. We use confidence intervals when we have no idea about the population parameter we are investigating. Additionally, we would use confidence intervals if we were asked for an estimate. You should use the relevant Excel templates provided in the dataset and copy them to the applicable question tab.

• Hypothesis Tests. You can assume that a 5% level of significance is appropriate. We use hypothesis tests when we are testing a claim, a theory or a standard. You should use the relevant Excel templates provided in the dataset and copy them to the applicable question tab.

• Sample size calculation: You can assume that a 95% confidence level is appropriate. You should include comparisons for 90% and 99% and a recommendation for the appropriate sample size.

• To answer some questions, you may need to make certain assumptions about the data set we are using. Mention these in your data analysis, where relevant. There is no need to mention this in the report.

Note: There is an appendix at the end of each chapter of the prescribed textbook which describes the basic Excel steps associated with that topic. Chapters 1 to 9 are applicable for this assessment