STAT 1182: Using Excel in First-Term Statistics Assignment 4
统计学作业代写 Experience has shown that the scores obtained in a particular test are Normally distributed with mean score 70 and standard deviation 6.
1.Refer to the Restaurants The dataset captures information on 300 restaurants and their quality rating and meal price (indollars).
1.Answer the following questions: 统计学作业代写
(a)The intention here is to cross tabulate Quality Rating (Good, Very Good, Excellent) and Meal Price (4 categories: Under $20, $20 to under $30, $30 to under $40, $40 and over). In other words, use Excel’s Pivot Table to create a 2-way table with Quality Rating and Meal Price as the two categorical variables. Your table must show the marginal counts as well. [4marks] [Explanation: Marginal counts are the totals on the margin (also called marginal distribution). In a 2-way table, you can add up the totals for each row and columns. Those totals are called marginal counts.]
(b)What percentage of meals under $20 are classified as Very Good? [1mark] 统计学作业代写
(c)What percentage of Excellent restaurants have meals under $20? [1mark]
(d)Using your values in part (a), create a side-by-side bar chart for the restaurant data with meal price on the horizontal axis and the count of restaurant on the vertical axis. [4marks]
(e)We wish to use the chi-square test of independence to assess if there is an association between Quality Rating and Meal Price. Use formulas to calculate the expected cell frequencies for each of the cell in your 2-way table (you may follow the steps on Page 252-253 of your textbook). [2 marks]
(f)Use Excel’s CHISQ.INV.RT (see textbook Page 254) or CHISQ.TEST to find the chi- square test statistic. [1mark]
(g)Draw your conclusion: Is there an association between Quality Rating and Meal Price among all restaurants? You may use a Decision Point to answer this question (decision point tables for Stat 1181 can be found in STAT 1182’s D2L website), or if you are comfortable interpreting using P-value, you may use Excel’s chi-square test output to draw a conclusion. [2 marks]
(continue next page)
2.The aim of this exercise is to construct the lower and upper boundaries of a confidence interval involving a population mean. 统计学作业代写
You may follow Page 139 of the textbook to complete the calculations for this exercise. 统计学作业代写
After a particular wet night, 12 earthworms surfaced on the lawn. Their lengths, measured in cm, were:
| 9.5 | 9.5 | 11.2 | 10.6 | 9.9 | 11.1 |
| 10.9 | 9.8 | 10.1 统计学作业代写 | 10.2 | 10.9 | 11.0 |
Assuming that this sample came from a Normal population with a standard deviation of 2 cm, calculate the 95% confidence interval for the mean length of all the earthworms in the lawn. [3 marks]
3.The aim of this exercise is to perform a hypothesis test involving a population mean where the population standard deviation is known.
You may follow Pg 131-138 of your textbook to complete the calculations involved in this exercise.
Experience has shown that the scores obtained in a particular test are Normally distributed with mean score 70 and standard deviation 6. When the test is taken by a random sample of 36 students, the mean score is 68.5. Is there sufficient evidence, at the 3% significance level, that these students have not performed as well as expected? 统计学作业代写
(a)Showing clearly how you obtain your answer, calculate the P-value for the test. [3marks]
(b)What conclusion can you draw at the 3% significance level? [1mark]
4.Take a look at the article by Cryer (on Brightspace/D2L under Assignment 4). 统计学作业代写
It is an old article that listed the deficiencies of using Excel as a statistical software. However, Microsoft has fixed many of these problems in the latest version of Excel.
Find on the internet an article that discusses the pros and cons (advantages and disadvantages) of using Microsoft Excel for statistical analysis. Submit the link, the title and a brief summary of the article. [3 marks] 统计学作业代写
Submitting your assignment: You must submit only ONE Excel file per assignment. All your answers must be in this single Excel file with properly labelled sheets.
其他代写：代写CS C++代写 java代写 matlab代写 web代写 作业代写 物理代写 数学代写 考试助攻 paper代写 r代写 金融经济统计代写 python代写 data代写
