ECON1030 Business Statistics ThuFri PROJECT 代写

ECON1030 Business Statistics ThuFri PROJECT 代写 |
Cover sheet for submission of work for assessment |

School: |
Economics, Finance and Marketing | |||

Program Name |
Program Code |
|||

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

Due Date |
Name of Lecturer |
||

Tutorial Day/Time |
Tutor’s Name |

Family name |
Given name |
Student number |

(1) |
||

(2) |
||

(3) |

ECON1030 Business Statistics ThuFri PROJECT 代写

(1) |

(2) |

(3) |

This is a

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.

A local used car dealer in Berlin has asked us to evaluate the price of premium vehicles. We have collected data on 1049BMWs listed on a used car website in 2016. They have provided us data on the price of the vehicle and characteristics of the vehicle such as age, kilometres driven, fuel used and the body style.

You will use

Price

A. Calculate the descriptive statistics fromthe data and display in a table. Be sure to comment on the

B. Draw a graph that displays the distribution of

C. Create a box-and-whisker plot for the distribution of

D. What is the probability that we could randomly select a vehicle that is a convertible?What is the likelihood that the age of a convertible exceeds 25 years? Is the age of a vehicle statistically independent of whether they are a convertible? Use a Contingency Table or Pivot Table to show the relative frequencies of these events. (2 Marks)

E. Estimate the 95% confidence interval for the population mean price of Hatchbacks. How does this compare to the 95% confidence interval for the population mean price of Coupes? (1 Mark)

F. It is traditionally believed that the less than the majority of convertibles in Germany have a manual transmission. Test the claim that the population proportion of Convertibles having a manual transmission is less than 50% at the 5% level of significance. (1 Mark)

G. Run a multiple linear regression using the data and show the output from Excel.Important: Exclude the dummy variable

H. Is the coefficient estimate for

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

K. Is the overall model statistically significant at the 5% level of significance? Use the p-value approach. (1/2 Mark)

L. Based on the results of the regressions, what other factors may have influenced the sale price of the used vehicles? Provide a couple possible examples and indicate their predicted relationship with sales if they were included. (1 Mark)

M. Predict the average price of a vehicle that is 5 years old, has an automatic transmission, has 75,000 kilometers, uses Petrol, has no damage, has a 110 kw engine, and the body style is a sedan. Discuss if it is appropriate to do predict under these conditions. 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. (1 1/2 Marks)

O. Does this data indicate the true population distribution of vehicle prices of BMWs in Berlin? Explain and if not, describe a sampling procedure that could lead to more accurate results. Would you expect these results to hold for Mercedes as well? (1 Mark)

P. The car dealer wants to display a random selection of 5 “high performance” vehicles on their website. They define “high performance” as having an engine exceeding 200kW. The dealer would generally like a mixture of body styles show up on the website. What is the probability that of those selected, all 5 vehicles would be sedans? What is the probability that none would be sedans? Create this using a Binomial Table and construct a bar chart to show the probability distribution of the number of vehicles that are sedans. (1 Mark)

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/2 Mark

Part H 2 Marks

Part I 2 Marks

Part J 1/2 Mark

Part K 1/2 Mark

Part L 1 Mark

Part M 1 Mark

Part N 1 1/2 Marks

Part O 1 Mark

Part P 1 Mark

ECON1030 Business Statistics ThuFri PROJECT 代写