Question

In: Statistics and Probability

Populate an excel sheet with the information, below. After you have installed the Analysis ToolPak, open...

Populate an excel sheet with the information, below. After you have installed the Analysis ToolPak, open “Data Analysis” and scroll down to “Regression” and click. The regression window will open. Run a regression analysis on the annual car sales, over the last three years, taken from William and Sam Automotive sales. Year Car Sales 2015 200 2016 250 2017 270.

Solutions

Expert Solution

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.970725343
R Square 0.942307692
Adjusted R Square 0.884615385
Standard Error 12.24744871
Observations 3
ANOVA
df SS MS F Significance F
Regression 1 2450 2450 16.33333333 0.154420958
Residual 1 150 150
Total 2 2600
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -70320 17459.07357 -4.027705119 0.154927474 -292158.5633 151518.5633 -292158.5633 151518.5633
Year 35 8.660254038 4.041451884 0.154420958 -75.03896087 145.0389609 -75.03896087 145.0389609

Car sales = -70320 + 35 * year

If you consider year 2015 =1 and year 2016=2 and 2017 =3

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.970725343
R Square 0.942307692
Adjusted R Square 0.884615385
Standard Error 12.24744871
Observations 3
ANOVA
df SS MS F Significance F
Regression 1 2450 2450 16.33333333 0.154420958
Residual 1 150 150
Total 2 2600
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 170 18.70828693 9.086882225 0.069778423 -67.71132404 407.711324 -67.71132404 407.711324
Year 35 8.660254038 4.041451884 0.154420958 -75.03896087 145.0389609 -75.03896087 145.0389609

Car sales = 170 + 35 * year

orchestra answered 1 year ago
Next > < Previous

Related Solutions

i. Use MS Excel Data Analysis ToolPak to perform a multiple regression analysis using Quality as...
i. Use MS Excel Data Analysis ToolPak to perform a multiple regression analysis using Quality as the response variable and Helpfulness and Clarity as the explanatory variables. Write down the corresponding coefficient estimates and provide the regression output. j. Perform an F-test for the overall usefulness of the model in part i) using a 5% significance level. Make sure you follow all the steps for hypothesis testing indicated in the Instructions section and clearly state your conclusion. k. Test manually...
Use Excel Analysis ToolPak to solve. Recent family home sales in San Antonio provided the following...
Use Excel Analysis ToolPak to solve. Recent family home sales in San Antonio provided the following data (San Antonio Realty Watch website, November 2008). Square Footage   Price ($) 1580   142,500 1572   145,000 1352   115,000 2224   155,900 1556   95,000 1435   128,000 1438   100,000 1089   55,000 1941   142,000 1698   115,000 1539   115,000 1364   105,000 1979   155,000 2183   132,000 2096   140,000 1400   85,000 2372   145,000 1752   155,000 1386   80,000 1163   100,000 a. Develop the estimated regression equation that can be used to predict...
Use Excel Analysis ToolPak to solve. Helmet   Weight   Price Pyrotect Pro Airflow    64   248 Pyrotect...
Use Excel Analysis ToolPak to solve. Helmet   Weight   Price Pyrotect Pro Airflow    64   248 Pyrotect Pro Airflow Graphics   64   278 RCi Full Face    64   200 RaceQuip RidgeLine    64   200 HJC AR-10    58   300 HJC Si-12   47   700 HJC HX-10   49   900 Impact Racing Super Sport   59   340 Zamp FSA-1   66   199 Zamp RZ-2   58   299 Zamp RZ-2 Ferrari   58   299 Zamp RZ-3 Sport   52   479 Zamp RZ-3 Sport Painted   52   479 Bell M2    63   369...
Use Excel Analysis ToolPak to solve. Helmet   Weight   Price Pyrotect Pro Airflow    64   248 Pyrotect...
Use Excel Analysis ToolPak to solve. Helmet   Weight   Price Pyrotect Pro Airflow    64   248 Pyrotect Pro Airflow Graphics   64   278 RCi Full Face    64   200 RaceQuip RidgeLine    64   200 HJC AR-10    58   300 HJC Si-12   47   700 HJC HX-10   49   900 Impact Racing Super Sport   59   340 Zamp FSA-1   66   199 Zamp RZ-2   58   299 Zamp RZ-2 Ferrari   58   299 Zamp RZ-3 Sport   52   479 Zamp RZ-3 Sport Painted   52   479 Bell M2    63   369...
Using the below information open an excel file and create a Sales Budget, a Cash Receipt...
Using the below information open an excel file and create a Sales Budget, a Cash Receipt Schedule and a Production Budget for Fiwrt for the months of Oct, Nov, and Dec. Make sure to use proper format including dollar signs and headers - this will count in the grade. Upload the excel file as your response. Fiwrt Corporation manufactures and sells stainless steel coffee mugs. Expected mug sales (in units) are expected to be as follows: September – 32,000, October...
Use Excel Analysis Toolpak to solve. Years   Sales 1   80 3   97 4   92 4   102...
Use Excel Analysis Toolpak to solve. Years   Sales 1   80 3   97 4   92 4   102 6   103 8   111 10   119 10   123 11   117 13   136 7   108 6   103 8   111 10   119 1   81 3   99 10   121 11   115 13   140 8.2   114 6   100 5   95 7   107 A sales manager collected the following data on x annual sales and y years of experience of salespersons. Required: a. Develop a scatter diagram with the...
Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below...
Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below Calculate the Net Working Capital and the Net Operating Working Capital for both years Perform vertical analysis on both statements, for both years Perform Horizontal analysis on both statements for the most current year What was the Net Operating Profit After Taxes for both years? 2016 Accounts Receivable 400 Sales 5000 Accounts Payable 650 Inventory 1400 COGS 3000 Common Stock 1500 Cash 1600 Oper....
After you have fully installed the Ubuntu© operating system to your company’s production servers, you are...
After you have fully installed the Ubuntu© operating system to your company’s production servers, you are now responsible for managing and monitoring the servers with Ubuntu© installed. You need to use the virtual environment that you set up with Ubuntu to do the following: Your team wants to deploy a new application on the servers that needs the latest Java© Development Kit (JDK) and GNU Compiler Collection (GCC). How do you check for which versions of these packages that are...
EXCEL SPREADSHEET New Product Analysis You have recently graduated with a BBA degree, and you have...
EXCEL SPREADSHEET New Product Analysis You have recently graduated with a BBA degree, and you have taken a job with a local manufacturing company. Your boss has asked you to analyze a potential new product, and to recommend if the company should produce and sell the product. Specifically, your boss wants you to prepare a spreadsheet that shows the free cash flows the product would generate, and shows what the product’s net present value and internal rate of return are...
Refer to the ‘Data Task A’ sheet in the accompanying Excel workbook. You have been provided...
Refer to the ‘Data Task A’ sheet in the accompanying Excel workbook. You have been provided the most recent Profit and Loss Statement for T&K Solutions that shows the bookkeeping service is losing money. Using the proforma in ‘Schedule 1’, re-calculate the 2017 profit for T&K Solutions without the bookkeeping service. Be careful to take into account all additional information provided in the ‘Data Task A’ worksheet. DATA FOR TASK A: 2017 Profit and Loss Statement for T&K Solutions: Taxation...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT