Homework Answers
increasing ad will increase the sales
| 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
...................
| 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:
Week 3 Simple Regression Forecasting Sales Problem Homework Assignment Using the Excel file Forecasting Sales Using...
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...
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...
Financial Planning and Forecasting: Using Regression to Improve Forecasts Regression analysis is a statistical technique that...
Financial Planning and Forecasting: Using Regression to Improve Forecasts Regression analysis is a statistical technique that fits a line to observed data points so that the resulting equation can be used to forecast other data points. It is useful in excess capacity and economies of scale situations. Economies of scale occur when the ratio of asset to sales will change as the size of the firm increases. Regression analysis can lead to improved financial forecasts and better information which can...
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...
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...
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 Xplotted 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...
Simple Linear regression 1. A researcher uses a simple linear regression to measure the relationship between...
Simple Linear regression
1. A researcher uses a simple linear regression to measure the relationship between the monthly salary (Salary measured in dollars) of data scientists and the number of years since being awarded a Master degree (Master Degree). A random sample of 80 observations was collected for the analysis. A researcher used the econometric model which has the following specification Salary,-β0 + β, Master-Degree, + εί, where i = 1, , 80 The (incomplete) Excel output of equation (1)...
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...
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...
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...
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...
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 Xplotted 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...
Simple Linear regression
1. A researcher uses a simple linear regression to measure the relationship between the monthly salary (Salary measured in dollars) of data scientists and the number of years since being awarded a Master degree (Master Degree). A random sample of 80 observations was collected for the analysis. A researcher used the econometric model which has the following specification Salary,-β0 + β, Master-Degree, + εί, where i = 1, , 80 The (incomplete) Excel output of equation (1)...
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...
Most questions answered within 3 hours.
-
Need help in drawing out a map pathway of pentose phosphate
pathway and pyruvate dehydrogenase/citric acid...
asked 1 minute ago -
Question 1
At the end of Year 6,
South Co.'s tax department estimates that they will...
asked 3 minutes ago -
Use standard enthalpies of formation to determine
ΔHorxn for:
1. 3NO2(g) + H2O(l) → 2HNO3(aq)
+...
asked 7 minutes ago -
Abigail Adams was hired as an associate professor of economics
at Heartland University. She was the...
asked 9 minutes ago -
consider the overall reaction: AB(g) + CB(g) ⟶ A(g) + CB2(g)
A proposed mechanism for this...
asked 16 minutes ago -
In fruit flies, assume bright red eyes (r) and curly wing (w)
are encoded by two...
asked 32 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 36 minutes ago -
C3H8 + 5O2 produces 3CO2 + 4
H2O
How many grams of CO2 are
produced by...
asked 37 minutes ago -
Select a target behavior from your list of potential target
behaviors. State your target behavior in...
asked 51 minutes ago -
Guns make a unique marking on the bullets they fire and their
shell casings. These markings...
asked 54 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