代写ECON 1030 – BUSINESS STATISTICS 1 PROJECT
100%原创包过,高质代写&免费提供Turnitin报告24小时客服QQ&微信：120591129
代写ECON 1030 – BUSINESS STATISTICS 1 PROJECT
School: 
Economics, Finance and Marketing 
Program Name 

Program Code 

Course/unit name 
Business Statistics 1 
Course/unit code 
ECON1030 





Due Date 
16 October 2016 
Name of Lecturer 

Tutorial Day/Time 

Tutor’s Name 

STUDENT/S
Family name 
Given name 
Student number 
(1) 


(2) 


(3) 


DECLARATION AND STATEMENT OF AUTHORSHIP
1. I/we hold a copy of this work which can be produced if the original is lost/damaged.
2. This work is my/our original work and no part of it has been copied from any other student’s work or from any other source except where due acknowledgement is made.
3. No part of this work has been written for me/us by any other person except where such collaboration has been authorized by the lecturer/teacher concerned.
4. I/we have not previously submitted this work for this or any other course/unit.
5. I/we give permission for this work to be reproduced, communicated, compared and archived for the purpose of detecting plagiarism.
6. I/we give permission for a copy of my/our marked work to be retained by the school for review and comparison, including review by external examiners.
I/we understand that:
7. Plagiarism is the presentation of the work, idea or creation of another person as though it is my/our own. It is a form of cheating and is a very serious academic offence that may lead to exclusion from the University. Plagiarised material can be drawn from, and presented in, written, graphic and visual form, including electronic data and oral presentations. Plagiarism occurs when the origin of the material used is not appropriately cited.
8. Plagiarism includes the act of assisting or allowing another person to plagiarise or to copy my/our work.
Student signature/s
I/we declare that I/we have read and understood the declaration and statement of authorship.
Further information relating to the penalties for plagiarism, which range from a notation on your student file to expulsion from the University, is contained in Regulation 6.1.1 Student Discipline and the Plagiarism Policy which are available on the Policies and Procedures website at www.rmit.edu.au/policies.
ECON 1030 – BUSINESS STATISTICS 1 PROJECT (FRIDAY)
Due: 16 October at 23:59
Instructions:
This is a
project where you can work alone or with two other students (a maximum group size of three).
All group members will receive the same marks for the assignment. All group members must be enrolled in the same tutorial. The assignment must be provided in the form of a (brief) business report approximately
8
14 pages. You must submit an
electronic copy of your assignment in Blackboard. Hard copies will not be accepted.
SHOW YOUR WORK for calculation based questions.
This assignment requires the use of Microsoft Excel. If you have Windows, you will also need to use the Data Analysis ToolPak. If you have a Mac with Excel 2011, you will need to use StatPlus:MAC LE.
Problem Description:
The Motion Picture Distributors Association of Australia has contacted us to explore recent film watching habits in theatres from the United States. It believes that sequels are increasingly a box office draw and that new intellectual properties are not receiving much attention. A sample of 77 films playing in 2015 through the United States has been collected. Several characteristics including gross revenue, the number of theatres screened, the metacritic score, whether it is a sequel as well as the genre have been included in the table.
You will use
descriptive statistics,
inferential statistics and your knowledge of
multiple linear regression to complete this task.
Price
(Dependent Variable) and several characteristics
(Independent Variables) are given in the Excel file: Friday.xlsx.
Here is a table describing the variables in the data set:
Variable 
Definition 
Gross 
Gross Revenue in Millions of US$ 
Theatres 
Number of theatres that screened the film 
Metacritic 
Metacritic score of the film 
Sequel/Reboot 
Dummy variable to indicate the film is either a sequel or a reboot of the franchise 
Action 
Dummy variable to indicate that the film is an action film 
Animation 
Dummy variable to indicate that the film is an animation 
Comedy 
Dummy variable to indicate that the film is a comedy film 
Drama 
Dummy variable to indicate that the film is a drama 
Thriller 
Dummy variable to indicate that the film is a thriller or horror film 
Required:
A. Calculate the descriptive statistics from the data and display in a table. Be sure to comment on the
central tendency, variability and shape for
Gross Revenue, Theatres, and Metacritic Score. How would you interpret the mean of dummy variables such as Sequel/Reboot or Action? (1 Mark)
B. Draw a graph that displays the distribution of the number of theatres that show a film. Be sure to comment on the distribution. (1 Mark)
C. Create a boxandwhisker plot for the distribution of the gross revenue and describe the shape. Is there evidence of outliers in the data? (1 Mark)
D. Film critics often believe that there is little correlation between a rating of a film and the revenue that it brings in. What is the likelihood that a film that receives a metacritic rating below a 50 still earns more than $90 million? Is the gross revenue statistically independent of the rating? Use a Contingency Table. (2 Marks)
E. Estimate the 90% confidence interval for the population mean film rating. (1 Mark)
F. Film critics also claim that film audiences do not care about the quality of the film. Any action film guarantees that it will gross more than $100 million. Test their claim at the 10% level of significance. (1 Mark)
G. Run a multiple linear regression using the data and show the output from Excel. Exclude the dummy variable “Thriller” from the regression results. (1 Mark)
H. Is the coefficient estimate for Theatres statistically different than zero at the 5% level of significance? Setup the correct hypothesis test using the results found in the table in Part (G) using both the critical value and pvalue approach. Interpret the coefficient estimate of the slope. (2 Marks)
I. Interpret the remaining slope coefficient estimates. Discuss whether the signs are what you are expecting and explain your reasoning. (2 Marks)
J. Interpret the value of the Adjusted R
^{2}. Is there a large difference between the R
^{2} and the Adjusted R
^{2}? If so, what may explain the reasoning for this? (1/2 Mark)
K. Is the overall model statistically significant at the 5% level of significance? Use the pvalue approach. (1/2 Mark)
L. Based on the results of the regressions, what other factors would have influenced the gross revenue? Provide a couple possible examples and indicate their predicted relationship with the gross revenue if they were included. (1 Mark)
M. Predict the average gross revenue of an action film with a metacritic score of 30 if it shows in 4,000 theatres, but it is not a sequel or a reboot if it is appropriate to do so. Show the predicted regression equation. (1 Mark)
N. Do the results suggest that the data satisfy the assumptions of a linear regression: Linearity, Normality of the Errors, and Homoscedasticity of Errors? Show using scatter diagrams, normal probability plots and/or histograms and Explain. (2 Marks)
O. Would these results likely tell us anything about how well Australianmade films will perform in Australia? If not, describe a scenario in how you would construct a sample of Australian films to predict their performance. (1 Mark)
代写ECON 1030 – BUSINESS STATISTICS 1 PROJECT