Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need Help is C and D of the question Consider the below data which is based on a company's sales in Year 1 through

I need Help is C and D of the question image text in transcribed

Consider the below data which is based on a company's sales in Year 1 through Year 12 along with the national income of the country, where the business is set up National Company's Income in sales in Year millions of thousands of dollars) dollars) y Year 1 305 470 Year 2 316 485 Year 3 358 499 350 515 Year 4 Year 5 375 532 Year 6 392 532 Year 7 400 556 Year 8 398 576 Year 9 430 583 Year 10 456 587 Year 11 578 601 Year 12 498 605 a. Develop a scatter chart for these data, treating the national income as the independent variable. Add a trendline in the chart. Does a simple linear regression model appe to be appropriate? b. Use Excel regression function to report the output and ANOVA table, develop an appropriate estimated regression equation to predict the company's sales, given the national Income. What will be the company's sales, if the national income is $500 million based on the estimated equation? C. How much variation in the sample values of companys sales is explained by this regression model is the overall regression relationship significant at a 0,05 level of significance? If so, then test the relationship between the independent variable and the dependent variable at a 0.05 level of significance. d. Show the residual plots using suing Excel regression function. Are there any concerns with the residual plots? Consider the below data which is based on a company's sales in Year 1 through Year 12 along with the national income of the country, where the business is set up National Company's Income in sales in Year millions of thousands of dollars) dollars) y Year 1 305 470 Year 2 316 485 Year 3 358 499 350 515 Year 4 Year 5 375 532 Year 6 392 532 Year 7 400 556 Year 8 398 576 Year 9 430 583 Year 10 456 587 Year 11 578 601 Year 12 498 605 a. Develop a scatter chart for these data, treating the national income as the independent variable. Add a trendline in the chart. Does a simple linear regression model appe to be appropriate? b. Use Excel regression function to report the output and ANOVA table, develop an appropriate estimated regression equation to predict the company's sales, given the national Income. What will be the company's sales, if the national income is $500 million based on the estimated equation? C. How much variation in the sample values of companys sales is explained by this regression model is the overall regression relationship significant at a 0,05 level of significance? If so, then test the relationship between the independent variable and the dependent variable at a 0.05 level of significance. d. Show the residual plots using suing Excel regression function. Are there any concerns with the residual plots

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Financial Literacy

Authors: Joan S. Ryan , Christie Ryan

3rd Edition

1337412686,1305980697

More Books

Students also viewed these Finance questions