代写 MCD2080: Business Statistics assignment

MCD2080: Business Statistics
Assignment 2: Linear Regression
Status           Individual
Hurdle Not applicable
Weighting    5%
Word limit   None
Due date      Monday of Teaching Week 11 by 10:00.
___________________________________________________________

This assignment is marked out of 35 and is worth 5% of the assessment in this unit.

Data and Output

You must use Excel to generate the relevant output. The file MCD2080_A2_T116.xlsx
·         contains the assignment data in the worksheet labelled Data.
·         has appropriately-labelledlocations for graphs, comments and tables in the Results worksheet.  Be sure to include your name and student ID in cells B1:B2.
We recommend that you
·         createyour graphs and tables in the Data worksheet. 
(You mustwork in this way on some computers, e.g. networked computers, because Excel’s Data Analysis Toolsmay work only on the worksheet where the data resides.)
·         then copy your graphs and tables to the appropriate locations in the Results worksheet.

Submission

·         Be sure to include your name and student ID in cells B1:B2 of the Results worksheet.
·         Your assignment submission is a printout of your completed Results worksheet. 
The Results worksheet has been set up to make printing easy, but it is your responsibility to ensure that all required information is printed on the pages that you hand in.
·         Do not print out the data in the Data worksheet.
·         The presentation of the assignment is important, and some marks are allocated for this.  Your work must be easy to read.  However, elaborate features are not required. 
·         For questions involving written comments, the size of the textboxes on the Results worksheet are an indication (based on 11-point font)of the length of comments required.You mayadjust the size and shape of the textboxes, especially when this is necessary to arrange the worksheet for printing. 
QUESTION

Background

A newly-opened jewellery repair shop recorded the daily number of watches repaired, and the revenue received from these repairs,for its first 30 days of business. See theData spreadsheet of MCD2080_A2_T116.xlsx. (Regard these 30 days as a random selection of the shop’s business days.)
All tables, graphs and comments for this question should be placed in the designated locations in the worksheet Results,with appropriate headings where required.
 
(a)    In Graph (a), produce a scatterplot of the data.
·         This chart must have an appropriate title and the axes must be labelled. 
(You may need to rescale the chart’s axes in order to clearly display the data.)
                                                                                       2 marks
 

2. In Textbox (b),

1. explain which is the dependent variable.
2. explain whether the relationship between these variable is probabilistic or deterministic.
3. from what you observe in the scatterplot, describe the relationship between the variables. 

3 marks
 
(c)    Using the Regression function in Excel’s Data Analysis Tools, generate regression output for the data and place it where indicated in the Results worksheet.  As a check that you have conducted the regression correctly, make sure that the standard error (fourth number in the output) is equal to 69.47255.
 
代写 MCD2080: Business Statistics assignment

In Textbox (c),test whether the data provides statistical evidence,at the 5% significance level,of a linear relationship between the daily number of watch repairs and the revenue received.
8 marks

4. In Textbox (d),

                     i.            write down the equation of the line of best fit for the data. 
Clearly indicate the variables used in your equation.
                   ii.            state the value of the intercept of the equation, correct to 3 decimal places.
Interpret this value. Discuss the validity of this value.
                 iii.            state the value of the slope of the equation, correct to 3 decimal places.
Interpret this value.
8 marks
 

5. In Textbox (e),state the value of the coefficient of correlation, correct to 3 decimal places.  Interpret this value.   

2 marks
 
(f)     In Textbox (f), state the 95% confidence interval for the slope coefficient, correct to 3 decimal places.  Interpret this interval.
4 marks
 

7. In Textbox (g),state the valueof the coefficient of determination, correct to 3 decimal places.  Interpret this value. Comment on goodness of fit.

3 marks
 
(h)   In Textbox (h), predict the revenue received from watch repairs when the daily number of watches repaired is
                    i.            24. Comment on the likely validity of this prediction.
                  ii.            36. Comment on the likely validity of this prediction.
5 marks
 
 
PresentationYour presentation should be easy to read.  Ease of reading is assisted by appropriate font size, borders, colour choice and labelling in graphs; and care in spelling, grammar and punctuation. Marks may be deducted for poor presentation.

代写 MCD2080: Business Statistics assignment