Homework Answers
| SUMMARY OUTPUT | |||||
| Regression Statistics | |||||
| Multiple R | 0.84795 | ||||
| R Square | 0.719019 | ||||
| Adjusted R Square | 0.683897 | ||||
| Standard Error | 67.19447 | ||||
| Observations | 10 | ||||
| ANOVA | |||||
| df | SS | MS | F | Significance F | |
| Regression | 1 | 92431.72 | 92431.72 | 20.4717 | 0.001938 |
| Residual | 8 | 36120.78 | 4515.097 | ||
| Total | 9 | 128552.5 |
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
| Intercept | 828.1269 | 136.1286 | 6.083416 | 0.000295 | 514.2138 | 1142.04 |
| ad | 10.78676 | 2.384042 | 4.524567 | 0.001938 | 5.289146 | 16.28437 |
Y = 828.1269 +10.7868*ad
increasing ad will increased sales
.................
| ad | sales | Predicted sales | error |
| 41 | 1250 | 1270.384 | -20.3839 |
| 54 | 1380 | 1410.612 | -30.6118 |
| 63 | 1425 | 1507.693 | -82.6926 |
| 54 | 1425 | 1410.612 | 14.38822 |
| 48 | 1450 | 1345.891 | 104.1088 |
| 46 | 1300 | 1324.318 | -24.3177 |
| 62 | 1400 | 1496.906 | -96.9058 |
| 61 | 1510 | 1486.119 | 23.88092 |
| 64 | 1575 | 1518.479 | 56.52064 |
| 71 | 1650 | 1593.987 | 56.01334 |
Please let me know in case of any doubt.
Thanks in advance!
Please upvote!
Add Answer to:
please help !
Week 3 Simple Regression Forecasting Sales Problem Homework Assignment Using the Excel file...
Week 3 Simple Regression Forecasting Sales Problem Homework Assignment Using the Excel file Forecasting Sales Using...
Week 3 Simple Regression Forecasting Sales Problem Homework Assignment Using the Excel file Forecasting Sales Using Ad Dollars Data use Excel to create a forecast of Sales $ using Ad $. Analyze the data using simple linear regression in Excel to answer the following questions. 1. Does more ad spending increase, decrease, or have no effect on sales $? 2. What is the regression equation? Write it and its numerical values. 3. Using the regression equation calculate predicted sales and...
х New Tab Week 3 Forecasting Sales Problem ws/kelly/Downloads/Week%203%20Forecasting%20Sales%20Problem.pdf x | + Week 3 Simple Regression...
х New Tab Week 3 Forecasting Sales Problem ws/kelly/Downloads/Week%203%20Forecasting%20Sales%20Problem.pdf x | + Week 3 Simple Regression Forecasting Sales Problem Homework Assignment Using the Excel file Forecasting Sales Using Ad Dollars Data use Excel to create a forecast of Sales $ using Ad $. Analyze the data using simple linear regression in Excel to answer the following questions. 1. Does more ad spending increase, decrease, or have no effect on sales $? 2. What is the regression equation? Write it and...
Using the Excel file Forecasting Sales Using Ad Dollars Data use Excel to create a forecast...
Using the Excel file Forecasting Sales Using Ad Dollars Data use
Excel to create a forecast of Sales $ using Ad $.
Analyze the data using simple linear regression in Excel to
answer the following questions.
Does more ad spending increase, decrease, or have no effect on
sales $?
What is the regression equation? Write it and its numerical
values.
Using the regression equation calculate predicted sales and
error values and enter them into the Excel spreadsheet in the
appropriate...
Multiple Linear Regression 20. The Excel file Concert Sales provides data on sales dollars and the...
Multiple Linear Regression
20. The Excel file Concert Sales provides data on sales dollars and
the number of radio, TV, and newspa-per ads promoting the concerts
for a group of cities. Develop simple linear regression models for
predict-ing sales as a function of the number of each type of ad.
Compare these results to a multiple linear regres-sion model using
both independent variables. State each model and explain R-Square,
Significance F, and p-values
from Business Analytics Methods, Models, and Decisions...
Ch 16: Assignment - Financial Planning and Forecasting Attempts: Keep the Highest: 12 5. Using regression...
Ch 16: Assignment - Financial Planning and Forecasting Attempts: Keep the Highest: 12 5. Using regression analysis to forecast assets The APN equation and the financial statement-forecasting approach both assume that assets grow at relatively the same rate as sales. However, the relationship between assets and sales is often a little more difficult than that. In particular, some firms use regression analysis to predict the required assets needed to support a given level of sales. U.S. Robotics Inc. has used...
Using Excel Sheet to answer the following make sure you submit the file with the work...
Using Excel Sheet to answer the following make sure you submit the file with the work required The following data represent the number of refrigerators sold for each of the past five months for Templeton Appliances. Month Sales 1. Using two-period Simple moving average to fill the rest of the table 2. Using forecasting command.The sale forecast for Month 6 is 3. Using forecasting command. The sale forecast for Month 7 is
Chapter 4 Forecasting Homework Assignment Daily high temperatures in St. Louis for the last week were...
Chapter 4 Forecasting Homework Assignment Daily high temperatures in St. Louis for the last week were as follows: 34, 36, 37, 39, 35, 32, and 36 (yesterday). Forecast the high temperature today, using a 3-day moving average. Forecast the high temperature today, using a 2-day moving average. For questions c-e use all the days where a 3-day forecast value is possible. Calculate the mean absolute deviation based on a 3-day moving average. Compute the mean squared error for the 3-day...
Instructions for Excel Assignment a) Using the data in the file (i.e., the values of Y...
Instructions for Excel Assignment
a) Using the data in the file (i.e., the values of Y and values
of X), create a scatter plot with the variable Y plotted vertically
and the variable X plotted horizontally. You are to add a
trendline, the equation of the line and R2 to this scatter plot.
You do not need to add a title to this plot.
b) Run the ‘Regression’ analysis tool (found under DATA/Data
Analysis). The output using this tool should...
Using the data in the folder for Data Folder in Course Documents, please run simple regression...
Using the data in the folder for Data Folder in Course Documents, please run simple regression model in Excel and, after the Summary Output is produced, in that same Excel file, do the following and then save when you have also Print your name on the top of that excel file in large Font, and reed color, save it and submit a it in this same folder. 1. use the Residual column (of that Excel Output YOU have produced), to...
Excel Assignment #2: Multiple Regression The Food Truck Case Study Overview and Objectives This a...
Gross Sales Distance to Neighborhood MedianNeighborhood NeighborhoodNumber Businesses Median Age Parking Dummy Variable Free Parking Nearby Location Day) University (mi) Residential Population within 5 mi 3 5 0 1 2 2 NeighborhoodNumber Businesses Parking Dummy Variable Free Parking Nearby Location(1 Day) University (mi) Residential Population within 5 mi 10400 9 1 Excel Assignment #2: Multiple Regression The Food Truck Case Study Overview and Objectives This assignment examines the case of a new food truck and the role that location plays...
Week 3 Simple Regression Forecasting Sales Problem Homework Assignment Using the Excel file Forecasting Sales Using Ad Dollars Data use Excel to create a forecast of Sales $ using Ad $. Analyze the data using simple linear regression in Excel to answer the following questions. 1. Does more ad spending increase, decrease, or have no effect on sales $? 2. What is the regression equation? Write it and its numerical values. 3. Using the regression equation calculate predicted sales and...
х New Tab Week 3 Forecasting Sales Problem ws/kelly/Downloads/Week%203%20Forecasting%20Sales%20Problem.pdf x | + Week 3 Simple Regression Forecasting Sales Problem Homework Assignment Using the Excel file Forecasting Sales Using Ad Dollars Data use Excel to create a forecast of Sales $ using Ad $. Analyze the data using simple linear regression in Excel to answer the following questions. 1. Does more ad spending increase, decrease, or have no effect on sales $? 2. What is the regression equation? Write it and...
Using the Excel file Forecasting Sales Using Ad Dollars Data use
Excel to create a forecast of Sales $ using Ad $.
Analyze the data using simple linear regression in Excel to
answer the following questions.
Does more ad spending increase, decrease, or have no effect on
sales $?
What is the regression equation? Write it and its numerical
values.
Using the regression equation calculate predicted sales and
error values and enter them into the Excel spreadsheet in the
appropriate...
Multiple Linear Regression
20. The Excel file Concert Sales provides data on sales dollars and
the number of radio, TV, and newspa-per ads promoting the concerts
for a group of cities. Develop simple linear regression models for
predict-ing sales as a function of the number of each type of ad.
Compare these results to a multiple linear regres-sion model using
both independent variables. State each model and explain R-Square,
Significance F, and p-values
from Business Analytics Methods, Models, and Decisions...
Ch 16: Assignment - Financial Planning and Forecasting Attempts: Keep the Highest: 12 5. Using regression analysis to forecast assets The APN equation and the financial statement-forecasting approach both assume that assets grow at relatively the same rate as sales. However, the relationship between assets and sales is often a little more difficult than that. In particular, some firms use regression analysis to predict the required assets needed to support a given level of sales. U.S. Robotics Inc. has used...
Using Excel Sheet to answer the following make sure you submit the file with the work required The following data represent the number of refrigerators sold for each of the past five months for Templeton Appliances. Month Sales 1. Using two-period Simple moving average to fill the rest of the table 2. Using forecasting command.The sale forecast for Month 6 is 3. Using forecasting command. The sale forecast for Month 7 is
Instructions for Excel Assignment
a) Using the data in the file (i.e., the values of Y and values
of X), create a scatter plot with the variable Y plotted vertically
and the variable X plotted horizontally. You are to add a
trendline, the equation of the line and R2 to this scatter plot.
You do not need to add a title to this plot.
b) Run the ‘Regression’ analysis tool (found under DATA/Data
Analysis). The output using this tool should...
Using the data in the folder for Data Folder in Course Documents, please run simple regression model in Excel and, after the Summary Output is produced, in that same Excel file, do the following and then save when you have also Print your name on the top of that excel file in large Font, and reed color, save it and submit a it in this same folder. 1. use the Residual column (of that Excel Output YOU have produced), to...
Gross Sales Distance to Neighborhood MedianNeighborhood NeighborhoodNumber Businesses Median Age Parking Dummy Variable Free Parking Nearby Location Day) University (mi) Residential Population within 5 mi 3 5 0 1 2 2 NeighborhoodNumber Businesses Parking Dummy Variable Free Parking Nearby Location(1 Day) University (mi) Residential Population within 5 mi 10400 9 1 Excel Assignment #2: Multiple Regression The Food Truck Case Study Overview and Objectives This assignment examines the case of a new food truck and the role that location plays...
Most questions answered within 3 hours.
-
The electric field in the region between two oppositely charged,
parallel, conducting plates has a magnitude...
asked 14 seconds ago -
A small body of mass m performs small oscillations sliding (no
rolling) along the bottom of...
asked 55 seconds ago -
A simple random sample was taken to test the claim that the
population mean is no...
asked 1 hour ago -
A set of length measurements are obtained with the values 165.6
± 0.3, 165.1± 0.4,166.4± 1.0,...
asked 1 hour ago -
1. Which of the following is true about unconscionable
contracts?
a. A term is substantially unconscionable...
asked 14 minutes ago -
A company is interested in estimating the costs of lunch
in their cafeteria. After surveying employees,...
asked 46 minutes ago -
A 0.2m diameter ball with an initial velocity of 8m/s rolls up a
hill without slipping....
asked 29 minutes ago -
I want to redraft the solution, using other words , use your own
words don't copy...
asked 18 minutes ago -
Hyundai Motors is considering threesites—A, B,C —at which to
locate a factory to build its new-model...
asked 20 minutes ago -
Learning Outcomes:
Upon the successful completion of this module, you should
understand the following concepts:
Strategic...
asked 21 minutes ago -
Identify four of the five major types of organizations within
the federal bureaucracy, and give examples...
asked 29 minutes ago -
The following data have been obtained
for the effect of solvent composition on the solubility of...
asked 30 minutes ago