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 spaces.
Homework Answers
| X | Y | Y1=828.13+10.79X | E=Y1-Y | |||||||
| Ad $ (thousands) | Sales ($ million) | Predicted Sales | Error | 1 | ||||||
| 41 | 1,250 | 1,270 | 20 | |||||||
| 54 | 1,380 | 1,411 | 31 | |||||||
| 63 | 1,425 | 1,508 | 83 | |||||||
| 54 | 1,425 | 1,411 | (14) | |||||||
| 48 | 1,450 | 1,346 | (104) | |||||||
| 46 | 1,300 | 1,324 | 24 | |||||||
| 62 | 1,400 | 1,497 | 97 | |||||||
| 61 | 1,510 | 1,486 | (24) | |||||||
| 64 | 1,575 | 1,518 | (57) | |||||||
| 71 | 1,650 | 1,594 | (56) | |||||||
| Click "Data" | ||||||||||
| Click "Data Analysis" | ||||||||||
| Select "Regression" tool | ||||||||||
| Click"OK" | ||||||||||
| Input y_Range (Sales) | ||||||||||
| Input x_Range (Rental Ad $) | ||||||||||
| Click "OK" | ||||||||||
| SUMMARY OUTPUT | ||||||||||
| Regression Statistics | ||||||||||
| Multiple R | 0.847950033 | |||||||||
| R Square | 0.719019259 | |||||||||
| Adjusted R Square | 0.683896667 | |||||||||
| Standard Error | 67.19447214 | |||||||||
| Observations | 10 | |||||||||
| ANOVA | ||||||||||
| df | SS | MS | F | Significance F | ||||||
| Regression | 1 | 92431.72331 | 92431.72331 | 20.47170228 | 0.0019382 | |||||
| Residual | 8 | 36120.77669 | 4515.097086 | |||||||
| Total | 9 | 128552.5 | ||||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||
| Intercept | 828.1268882 | 136.1285978 | 6.083415987 | 0.000294814 | 514.2137788 | 1142.04 | 514.2138 | 1142.04 | ||
| X Variable 1 | 10.7867573 | 2.384042146 | 4.52456653 | 0.0019382 | 5.289146253 | 16.28437 | 5.289146 | 16.28437 | ||
| Regression Equation : | ||||||||||
| Y=a+bX | ||||||||||
| a=Intercept= | 828.13 | |||||||||
| b=X Variable1= | 10.79 | |||||||||
| Y=828.13+10.79X | ||||||||||
| R Square value = | 0.719019259 | |||||||||
| This indicates reasonably good correlation between Ad$ and Sales | ||||||||||
Add Answer to:
Using the Excel file Forecasting Sales Using Ad Dollars Data use
Excel to create a forecast...
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...
please help ! Week 3 Simple Regression Forecasting Sales Problem Homework Assignment Using the Excel file...
please help !
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...
х 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...
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...
5. Using regression analysis to forecast assets The AFN equation and the financial statement-forecasting approach both...
5. Using regression analysis to forecast assets The AFN 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. Mainway Toys Co. has used its historical sales and asset data to estimate the following regression equations: Accounts...
5. Using regression analysis to forecast assets The AFN equation and the financial statement–forecasting approach both...
5. Using regression analysis to forecast assets The AFN 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. Mile Brewing Co. has used its historical sales and asset data to estimate the following regression equations: Accounts...
Instructions for Excel Assignment 2 a) Using the data in the file (i.e., the values of...
Instructions for Excel Assignment 2 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 R 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...
Instructions for Excel Assignment 2 a) Using the data in the file (i.e., the values of...
Instructions for Excel Assignment 2 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 R 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...
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...
Please use Excel Solver. Consider the following set of time series sales data for a growing...
Please use Excel Solver.
Consider the following set of time series sales data for a growing company over the past 8 months: Month Sales 1 15 2 13 18 4 22 20 6 23 7 22 8 21 1. Construct a time series plot. What type of pattern exists? 2. Develop a forecast for the next month using the averaging method. 3. Develop a forecast for the next month using the naïve last-value method. 4. Develop a forecast for the...
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...
please help !
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...
х 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...
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...
5. Using regression analysis to forecast assets The AFN 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. Mainway Toys Co. has used its historical sales and asset data to estimate the following regression equations: Accounts...
Instructions for Excel Assignment 2 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 R 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...
Instructions for Excel Assignment 2 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 R 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...
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...
Please use Excel Solver.
Consider the following set of time series sales data for a growing company over the past 8 months: Month Sales 1 15 2 13 18 4 22 20 6 23 7 22 8 21 1. Construct a time series plot. What type of pattern exists? 2. Develop a forecast for the next month using the averaging method. 3. Develop a forecast for the next month using the naïve last-value method. 4. Develop a forecast for the...
Most questions answered within 3 hours.
-
Use standard enthalpies of formation to determine
ΔHorxn for:
1. 3NO2(g) + H2O(l) → 2HNO3(aq)
+...
asked 4 minutes ago -
Abigail Adams was hired as an associate professor of economics
at Heartland University. She was the...
asked 7 minutes ago -
consider the overall reaction: AB(g) + CB(g) ⟶ A(g) + CB2(g)
A proposed mechanism for this...
asked 13 minutes ago -
In fruit flies, assume bright red eyes (r) and curly wing (w)
are encoded by two...
asked 29 minutes ago -
Consider the compounds represented by the following names:
Compound A: 2,3-dimethylpentane Compound B: 3,4-dimethyl-3-pentene
Compound C:...
asked 34 minutes ago -
C3H8 + 5O2 produces 3CO2 + 4
H2O
How many grams of CO2 are
produced by...
asked 34 minutes ago -
Select a target behavior from your list of potential target
behaviors. State your target behavior in...
asked 48 minutes ago -
Guns make a unique marking on the bullets they fire and their
shell casings. These markings...
asked 51 minutes ago -
Bourque Enterprises is considering a new project. The project
will generate sales of $1.5 million, $2.2...
asked 1 hour ago -
data structures c++
please implement the QuickSort algorithm as a C++ function. Use
it to sort...
asked 1 hour ago -
A young investment manager tells his client that the probability
of making a positive return with...
asked 1 hour ago -
Calculate the final discrete available-to-promise quantity for
Week 1 using the following table.
Weeks
1
2...
asked 1 hour ago