Question below
In this exercise, please choose one of three topics to write short statistical analytical report topics on.
For any of the following topic, you would need to use minimum three statistical tests that you have learned in Bus 231. The statistical analysis section of your report should be addressed to a knowledgeable group of audience who has some basic understanding of statistics. You conclusion and review should be written in the purpose of communicating with the general public. A sample is provided
Final Project – Checklist
(15 pts) Overall appearance/presentation of written report-
Is it professional and easy to read? Are the Excel files included?
(10 pts) Introduction/Overview
For each of the 3 tests (or more):
(5pts) Statement of issues, explanation of analysis and correct selection of variables to be analyzed
(15 pts) Correct selection and application of analytical tests (5 pts) Conclusions and recommendations
Topic 1: Canadian National Debt
Debt securities are believed to burden, and slow down the economy. Is this belief true? Generally, Debt securities are affected by interest rates. However, with many different kinds of interest rate, which one in the Canadian economy that affects the debt securities the most? After selecting the right interest rate, can you build a regression model to explain the variation in Debt?
The data is in Topic 1 national debt.xlsx attached
Topic 2: Profits made at Car Dealerships
Applewood is a corporation that specializes in selling economy automobiles. . The data of sales from all four locations are tallied.
The CEO of Applewood Corp would like to see
- which dealership (Kane, Olean, Sheffield, and Tionesta) performs the best in terms of making the most profit
- whether the sale numbers for different types of vehicles are the same. Please test that assumption also use goodness-of-fit test. Please write an analytical report on your statistical result.
- what explains the variations in profits of the sales, please develop a model to help you answer this question.
attached
Topic 3: BC Housing Market
Housing market is proven to be the most versatile market responding to any major changes in an economy. As a market analyst, you are hoping to find out what factors that contributes to the housing sales volume. After selecting the right variables, you will be expected to build a regression model to explain the variations in housing sales. However, housing price is correlated with other variables as well. How would you deal with this problem in your model?
attached
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
