Business Statistics代考 analysis and application代写

2021 September Semester (213)

FINAL semester ASSESSMENT

STAT11-111/STAT71-105

BUSINESS STATISTICS/analysis and application

 Business Statistics代考 You must complete this assessment by yourself using only the approved materials listed on the following page.

 For examiners use only

Manual Calculations Section

You may either use Word to record your answers or scan your answers from a written page.  The filename must be based on your student number.  As examples, “1312345.docx” and “1312345.pdf”.  Your document must not contain your name. Penalties may result if the above is not strictly followed.

Question 1       Business Statistics代考                                                                                                             

The CEO of EG Burgers, Emily Grace, wants to determine if queue waiting times are higher during the COVID pandemic than before the pandemic. A sample of 40 customers surveyed during the pandemic revealed a mean waiting time of 7 minutes. EG Burgers knows that the historical standard deviation of waiting time is 1.1 minutes and the mean waiting time is 6.5 minutes. Using α=0.01, test the CEO’s hypothesis.  [_15_marks]

Question 2       

A new training course has been implemented at EG Burgers in the hope of decreasing the time it takes to make the new Flaming Wing™ hamburger. The time taken (in minutes) to create the burger is measured for four workers before and after the training course, and is given below:

Is there evidence of a decrease in the time it takes to make the new burger after the training course? Test at the 10% level of significance.                                                                                                                                                                                       [_15_marks]

Question 3

EG Water is a very popular item at EG Burgers. During the manufacturing stage, the bottles are filled according to a normal distribution with a population mean of 500 mL and population standard deviation of 25 mL.

a)What is the probability that the bottles will have more than 510 mL in them?

b)What lower and upper volumes of water are contained within 20% of the bottles symmetrically distributed either side of the mean?

c)Given a random sample of 50 bottles, what is the probability that the sample mean is below 495 mL?

                                                                                                                        [_20_marks]

EXCEL Section

Put each question in a new tab and label each tab according to the question number. For example, “Question 1”. Name the Excel file using your student number, for example, “1312345.xlsx”. Your file must not contain your name. Penalties may result if the above is not strictly followed. Use of the Data Analysis ToolPak in Excel is required.

Question 1

The CEO of EG Burgers, Emily Grace, suspects that sales of the new Flaming Wing ™ hamburger are greater in their Northport restaurant than their Narrowbeach restaurant.  To test this, the company counted the number of burgers sold during ten randomly selected days.  The resulting data are represented in the table below:

Do these data support the hypothesis CEO’s hypothesis? Test at the 10% level of significance.

                                                                                                                   [_15_marks]

Question 2  Business Statistics代考

The number of bottles of EG Water and Flaming Wing™ hamburgers sold over ten consecutive days were recorded at EG Burger’s Frond Beach restaurant in the table below.  The CEO of EG Burgers, Emily Grace, is interested in predicting the number of EG Water bottles sold.

a)Determine the regression equation.

b)Interpret the estimated intercept and gradient coefficients.

c)Is there a linear relationship between number of Flaming Wing™and EG Water bottles sold? Test at the 1% level of significance.

d)Find and interpret the coefficient of determination.

e)Based on the model you estimated in part a), how many Flaming Wing™hamburgers are likely to be sold for there to have been 1110 EG Water bottles sold?

                                                                                                           [_15_marks]

Question 3   Business Statistics代考

EG Burgers is looking to add a new restaurant. The CEO, Emily Grace, decides to use a regression model to help select the location of the new restaurant. She decides to use the annual gross revenue for her current restaurants as the selection criterion/dependent variable.   She believes that the determinants of revenue include the following variables:

• Number of people living within 1km of the restaurant (PEOPLE)
• The average number of vehicles passing the restaurant on a daily basis (TRAFFIC)
• A logical variable (set to either Yes or No) about whether there are competitors within a 5km radius of the restaurant (COMPTORS)

Emily Grace randomly selects twenty of her existing restaurants and has her team gather the values for the variables for these, along with their annual gross revenues (REVENUE) in tens of thousands of dollars.  The following table gives the values of the variables for the twenty restaurants:

a)Estimate the appropriate model and find the estimated regression equation.

b)Examine the overall significance of the model at the 1% level of significance.

c)0Eliminate the statistically irrelevant factors at the 5% level of significance, if any, and re-estimate the model with the relevant factors.

                                                                                                                       [_20_marks]

更多代写：代修夏季网课写  duolingo english test作弊  财政金融代写  北美MBAEssay代写  北美留学论文代写   学术论文写作

合作平台：essay代写 论文代写 写手招聘 英国留学生代写