代写 ECON 1030 – BUSINESS STATISTICS  经济 统计学

ECON 1030 – BUSINESS STATISTICS 1
GROUP ASSIGNMENT (Monday Tutorial)
Marks: 20
Due: 29 May at 11:59 PM (Week 12)
 
Instructions:
                                                    
This is an optionalgroup assignment with a minimum group size of one and 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 reportapproximately 6-10 pages (including this cover page). You must submit an electroniccopy of your assignment in Blackboard.  Hard copies will not be accepted.SHOW YOUR WORK for Calculation based questions if you wish to receive partial credit.
 
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.
 
Group Members:
 

First name	Last name	StudentID

 
Please indicate your tutor and tutorial time:
 

Tutor
Tutorial date and time

 
 

 
Problem Description:
Before heading to the beach in the afternoon in mid-winter, hardy Sydney surfers are very interested in what the likely temperature will be given the temperatures at breakfast time.  Afternoon temperatures, however, are also likely to be affected by other meteorological factors, such as precipitation and sunshine.  The data below relate to daily temperatures in Sydney, July 2015 at 9 am and 3 pm, as well as: rainfall in the 24 hours to 9 am; evaporation in the 24 hours to 9 am; hours of bright sunshine in the 24 hours to midnight the day before.
 
You will use descriptive statistics, inferential statisticsand your knowledge of multiple linear regression to complete this task.
 
Temperatureat 3 pm (Dependent Variable)and several characteristics (Independent Variables) are given in the Excel file: Monday.xlsx.
 
Here is a table describing the variables in the data set:

Variable	Definition
Rain (mm)	Millimetres of rain in 24 hours to 9 am
Evaporation (mm)	Millimetres of water evaporation in the 24 hours to 9 am
Sun (hours)	Number of hours of sun in the 24 hours to midnight, the day before
9 am Temp	The temperature at 9 am
3 pm Temp	The temperature at 3 pm

 

 
Required:
 
A.     Calculate the descriptive statistics fromthe data and display in a table.  Be sure to comment on the central tendency,variabilityand shape for each variable. (1 Mark)
B.     Draw a graph that displays the distribution of the temperature at 3 pm. (1 Mark)
C.     Create a box-and-whisker plot for the distribution of rain and describe the shape.  Is there evidence of outliers in the data? (1 Mark)
D.     What is the likelihood that the 3 pm temperature is no less than 17 degrees if it has rained in the 24 hours prior to 9 am?Is the temperature statistically independent of rain?  Use a Contingency Table. (2 Marks)
E.      Estimate the 90% confidence interval for the population mean hours of sun. (1 Mark)
F.      Your supervisor recently stated that it is obvious that the mean 3 pm temperature is greater thanthe long-run average of 17.3 degrees Celsius.  Test her claim at the 1% level of significance. (1 Mark)
G.     Run a multiple linear regression using the data and show the output from Excel. (1 Mark)
H.     Is the coefficient estimate for the rain total statistically different than zero at the 5% level of significance?  Set-up the correct hypothesis test using the results found in the table in Part (G) using both the critical value and p-value approach.  Interpret the coefficient estimate of the slope. (2 Marks)
I.        Interpret the remaining slope coefficient estimates.Comment on whether the signs are what you are expecting. (2 Marks)
J.       Interpret the value of the Adjusted R². Is the overall model statistically significant at the 1% level of significance?  Use the p-value approach. (1 Mark)
K.    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. (3 Marks)
L.      Based on the results of the regressions, is it likely that other factors have influencedthe afternoon temperature?  If so, provide a couple possible examples and indicate whether these would likely influence the regression results if they were included. (1 Mark)
M.   If a community housing organisation asked for information regarding the characteristics of housing targeting the households of Aboriginal and Torres Strait islanders, explain whether a simple random sampling technique would provide an accurate representation of these households. (Note: This question does not use the data)(1 Mark)
 
代写 ECON 1030 – BUSINESS STATISTICS  经济 统计学

ECON 1030 – BUSINESS STATISTICS 1
GROUP ASSIGNMENT (Wednesday Tutorial)
Marks: 20
Due: 29 May at 11:59 PM (Week 12)
 
Instructions:
                                                    
This is an optionalgroup assignment with a minimum group size of one and 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 reportapproximately 6-10 pages (including this cover page). You must submit an electroniccopy of your assignment in Blackboard.  Hard copies will not be accepted.SHOW YOUR WORK for Calculation based questions if you wish to receive partial credit.
 
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.
 
Group Members:
 

First name	Last name	StudentID

 
Please indicate your tutor and tutorial time:
 

Tutor
Tutorial date and time

 
 

 
Problem Description:
Some film distributors offer discount cinema tickets via email.  Suppose that a random sample of 25 movie-goers is undertaken, and suppose that the number of movies the person has seen in the last year, their age and income, and the number of discount cinema tickets they have received via e-mail in the last year, is recorded.
 
You will use descriptive statistics, inferential statisticsand your knowledge of multiple linear regression to complete this task.
 
Number of movies seen(Dependent Variable)and several characteristics (Independent Variables) are given in the Excel file: Wednesday.xlsx.
 
Here is a table describing the variables in the data set:

Variable	Definition
Movies Seen	Number of Movies seen at the theatre in the last year
Age	Age of respondent
Number Discount	Number of discounted tickets received by the respondent via e-mail
Income ($000)	Income of respondent in thousands of dollars

 

 
Required:
 
A.     Calculate the descriptive statistics fromthe data and display in a table.  Be sure to comment on the central tendency,variabilityand shape for each variable. (1 Mark)
B.     Draw a graph that displays the distribution of movies seen. (1 Mark)
C.     Create a box-and-whisker plot for the distribution of the Number of discounted tickets and describe the shape.  Is there evidence of outliers in the data? (1 Mark)
D.     What is the likelihood that movies seen is at least 10 per year if the age of the respondent is at least 40?Are movies seen statistically independent of age?  Use a Contingency Table. (2 Marks)
E.      Estimate the 95% confidence interval for the population mean number of discounts received of the respondents. (1 Mark)
F.      Your supervisor recently stated that movie goers are more affluent than the general public who has an average wage of $57,900. Test his claim at the 5% level of significance. (1 Mark)
G.     Run a multiple linear regression using the data and show the output from Excel. (1 Mark)
H.     Is the coefficient estimate for the number of discounted e-mail tickets different than zero at the 1% level of significance?  Set-up the correct hypothesis test using the results found in the table in Part (G) using both the critical value and p-value approach.  Interpret the coefficient estimate of the slope. (2 Marks)
I.        Interpret the remaining slope coefficient estimates.Comment on whether the signs are what you are expecting. (2 Marks)
J.       Interpret the value of the Adjusted R². Is the overall model statistically significant at the 1% level of significance?  Use the p-value approach. (1 Mark)
K.    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. (3 Marks)
L.      Based on the results of the regressions, is it likely that other factors have influencedthe number of movies seen?  If so, provide a couple possible examples and indicate whether these would likely influence the regression results if they were included. (1 Mark)
M.   If a community housing organisation asked for information regarding the characteristics of housing targeting the households of foreign-born Australians in Melbourne, explain whether a clustered sampling technique of the CBD would provide an accurate representation of these households. (Note: This question does not use the data)(1 Mark)
 

 
Allocation of Marks:
Professional Business Report             2 Marks
Part A                                1 Mark
Part B                                1 Mark
Part C                                1 Mark
Part D                                2 Marks
Part E                                 1 Mark
Part F                                 1 Mark
Part G                                1 Mark
Part H                                2 Marks
Part I                                  2 Marks
Part J                                 1 Mark
Part K                                3 Marks
Part L                                 1 Mark
Part M                                1 Mark
Total:                                20 Marks

代写 ECON 1030 – BUSINESS STATISTICS  经济 统计学