12 May WHICH OF THE MODELS DO YOU PREFER? WHY?
Run a regression using the given data. (With Profit as the dependent variable and Dealership Store size as the independent variable)2. Compare the results of question (1) with another regression equation obtained by regressing the Profit on the variables : Sedan Sales and Suv sales.3. Which of the models do you prefer? Why?4. Interpret your results for (1) and (2).5. In writing your paper, you should start by indicating the objectives of the study and value addition thereof from the business context. Also, discuss the methodology and conclusionsYou can submit your work either as a PDF or WORD File (Make sure Only ONE file issubmitted) You can attach your Excel file as your appendix (only ONE Excel file is allowed)*Only one Word or PDF file and one Excel file should be submitted in the drop box Due: Thursday, August 3, 2017 by 06:00 p.m (Central Time) ProfitsUse the given Sample data for profits made by Car Dealers and follow the instructions below: Instructions1. Run a regression using the given data. (With Profit as the dependent variable and DealershipStore size as the independent variable)2. Compare the results of question (1) with another regression equation obtained by regressing theProfit on the variables : Sedan Sales and Suv sales.3. Which of the models do you prefer? Why?4. Interpret your results for (1) and (2).5. In writing your paper, you should start by indicating the objectives of the study and valueaddition thereof from the business context. Also, discuss the methodology and conclusions.**Range: 5 pages + Excel printout results****You can use EXCEL or any other software**** You need to include your printout in your submissions** Paper FormatThe layout and format of the paper should include the following sections:Title page, Abstract, Introduction, Methodology, Empirical-Results, and Discussion,Conclusions.a) Abstract: is a very concise summary of the paper.b) Introduction: Tells the reader about the topic. Specifically, it should start with the purpose ofthis paper is to examine. What the issue is, what is known about it, and the specific focus? Put1 a business context to it – write the value added by your work or what businesses can gain fromthe knowledge of the determinants of incomes.c) Methodology: You should be able to explain what method you are using for your work. Forexample, you can start with telling the reader that the ordinary least squares method (OLS) wasused to obtain estimated coefficients… (Then write more). You should be able to write theequation from the Excel result. We expect to see you1. Using the excel result to generate the equation.2. Find the standard error of each variable.3. Find the t-stat of each variable.4. Find the p-value of each variable.5. Find the F-value of the equationsEXAMPLE:? = 1.24 + 1.71X1 – 0.83X2 – 2.12X3(6.79) (1.43) (0.22) (0.85) T-stat [0.18] [1.20] [3.78] [2.48] P-value 0.857 0.247 0.002 0.025 d) Empirical-Results: Should tell what was found from the computed data. Using Chapter 10 and 11 forhelping you interpret your result. For instance, you should interpret the Coefficient of Determination ( ),F-test, t-test, p-value and etc. In addition, your result should use the hypothesis equation.e) Discussion: Describes what your findings mean in the light of the information presented in theintroduction. It is the interpretive segment of the paper and loops back to answer the issues raised in theintroduction. Remember to discuss questions 2 and 3.f) Conclusion: What conclusion would you draw based on your study.**Remember that the results section should include hypothesis testing for a t-test about each slopecoefficient and an F-test for the overall regression model.EXAMPLE:For the t-test, it is written like this:Note: You have to decide whether to use one-tail or two-tail test You need to follow chapter 9 materials and declare your alternative hypothesis in each casevery wellF-test: Note: mention what ? is used in your hypothesis testing. 2 Data Sample Data for Profits of Car DealersDealer Number Sedan Sales Suv Sales 12345678910 366156227210121323505234338244 421181009111292536837110 Dealership Size (Inthousands sq ft)42263219345567144838 Profit (In thousands)480360400220380640840160520560 How to Submit Your JournalRun a regression using the given data. (With Profit as the dependent variable and Dealership Store size as the independent variable)2. Compare the results of question (1) with another regression equation obtained by regressing the Profit on the variables : Sedan Sales and Suv sales.3. Which of the models do you prefer? Why?4. Interpret your results for (1) and (2).5. In writing your paper, you should start by indicating the objectives of the study and value addition thereof from the business context. Also, discuss the methodology and conclusionsYou can submit your work either as a PDF or WORD File (Make sure Only ONE file issubmitted) You can attach your Excel file as your appendix (only ONE Excel file is allowed)*Only one Word or PDF file and one Excel file should be submitted in the drop box Due: Thursday, August 3, 2017 by 06:00 p.m (Central Time) ProfitsUse the given Sample data for profits made by Car Dealers and follow the instructions below: Instructions1. Run a regression using the given data. (With Profit as the dependent variable and DealershipStore size as the independent variable)2. Compare the results of question (1) with another regression equation obtained by regressing theProfit on the variables : Sedan Sales and Suv sales.3. Which of the models do you prefer? Why?4. Interpret your results for (1) and (2).5. In writing your paper, you should start by indicating the objectives of the study and valueaddition thereof from the business context. Also, discuss the methodology and conclusions.**Range: 5 pages + Excel printout results****You can use EXCEL or any other software**** You need to include your printout in your submissions** Paper FormatThe layout and format of the paper should include the following sections:Title page, Abstract, Introduction, Methodology, Empirical-Results, and Discussion,Conclusions.a) Abstract: is a very concise summary of the paper.b) Introduction: Tells the reader about the topic. Specifically, it should start with the purpose ofthis paper is to examine. What the issue is, what is known about it, and the specific focus? Put1 a business context to it – write the value added by your work or what businesses can gain fromthe knowledge of the determinants of incomes.c) Methodology: You should be able to explain what method you are using for your work. Forexample, you can start with telling the reader that the ordinary least squares method (OLS) wasused to obtain estimated coefficients… (Then write more). You should be able to write theequation from the Excel result. We expect to see you1. Using the excel result to generate the equation.2. Find the standard error of each variable.3. Find the t-stat of each variable.4. Find the p-value of each variable.5. Find the F-value of the equationsEXAMPLE:? = 1.24 + 1.71X1 – 0.83X2 – 2.12X3(6.79) (1.43) (0.22) (0.85) T-stat [0.18] [1.20] [3.78] [2.48] P-value 0.857 0.247 0.002 0.025 d) Empirical-Results: Should tell what was found from the computed data. Using Chapter 10 and 11 forhelping you interpret your result. For instance, you should interpret the Coefficient of Determination ( ),F-test, t-test, p-value and etc. In addition, your result should use the hypothesis equation.e) Discussion: Describes what your findings mean in the light of the information presented in theintroduction. It is the interpretive segment of the paper and loops back to answer the issues raised in theintroduction. Remember to discuss questions 2 and 3.f) Conclusion: What conclusion would you draw based on your study.**Remember that the results section should include hypothesis testing for a t-test about each slopecoefficient and an F-test for the overall regression model.EXAMPLE:For the t-test, it is written like this:Note: You have to decide whether to use one-tail or two-tail test You need to follow chapter 9 materials and declare your alternative hypothesis in each casevery wellF-test: Note: mention what ? is used in your hypothesis testing. 2 Data Sample Data for Profits of Car DealersDealer Number Sedan Sales Suv Sales 12345678910 366156227210121323505234338244 421181009111292536837110 Dealership Size (Inthousands sq ft)42263219345567144838 Profit (In thousands)480360400220380640840160520560 How to Submit Your Journal
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.