Question

Number 2 A regression analysis of 62 months’ data relating a company's monthly advertising expenses (x,...

Number 2 A regression analysis of 62 months’ data relating a company's monthly advertising expenses (x, in thousands of dollars) to its sales (y, in thousands of dollars) yields the following output:

  • • ?0=100
  • • ?1=5.3
  • • Standard error of the estimate ?=??=56
  • • Standard error for ?1, ???1=0.3

Furthermore, when ?∗=9, the standard error for a confidence interval for the estimated mean response is given by ???̂=29, while the standard error for a prediction interval is ???̂=63.1.

  • (a) (3 pts) Is the regression significant at a 5% level of significance?
  • (b) (3 pts) Say that the company spends $9000 on advertising in a given month. What would you expect their sales to be?
  • (c) (3 pts) Find a 95% confidence interval for the average sales over all months in which they plan to spend $9000 on advertising.
  • (d) (3 pts) Assume that you know that in January of 2020, they spent $9000 on advertising, but you don’t have
0 0
Add a comment Improve this question Transcribed image text
Answer #1

y^ = 100 + 5.3 x

a)

TS = b1^ / se(b1^)

= 5.3 / 0.3 = 17.6667

p-value = 2 P(t > |TS| ) = 0

since p-value < alpha

regression is significant

b)

y^ = 100 + 5.3* x

= 100 + 5.3 * 9 = 147.7

c)

df =n-2 = 60

(147.7 +- 63.1)

= (84.6,210.8)

Please give me a thumbs-up if this helps you out. Thank you! :)

Add a comment
Know the answer?
Add Answer to:
Number 2 A regression analysis of 62 months’ data relating a company's monthly advertising expenses (x,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A large corporation is interested in whether advertising on TV has had an effect on sales...

    A large corporation is interested in whether advertising on TV has had an effect on sales of their products. Data have been collected in ?=20n=20 different markets on the spend on TV advertising (?x, measured in thousands of dollars) and product sales (?y, measured in thousands of units). The following are useful summaries of the data: A large corporation is interested in whether advertising on TV has had an effect on sales of their product: Data have been collected in...

  • Quick-print firms in a large downtown business area spend most of their advertising dollars on displays...

    Quick-print firms in a large downtown business area spend most of their advertising dollars on displays on bus benches. A research project involves predicting monthly sales based on the annual amount spent on placing ads on bus benches. A sample of quick-print firms revealed these advertising expenses and sales. Annual Bus Bench Advertising ($ thousands)thousands) Firm Monthly Sales 10 40 30 50 20 4 a.)Determine whether a significant linear relationship exists between these two variables using the.05 significance level b.)Determine...

  • A regression model relating x, number of salespersons at a branch office, to y, annual sales...

    A regression model relating x, number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following computer output from a regression analysis of the data. Where n total=26. a. Write the estimated regression equation (to whole number). y=_____+_____x b. Compute the F statistic and test the significance of the relationship at a .05 level of significance. (to 2 decimals) F-value ____ p-value is _______, we _________ h0 c. Compute the...

  • Part 2: Simple Linear Regressions – Chapter 14 (2 questions with a total of 11 sub-sections,...

    Part 2: Simple Linear Regressions – Chapter 14 (2 questions with a total of 11 sub-sections, 6 points per sub-section, part total 66 points) 2) A local grocery store wants to predict its daily sales in dollars (y). The manager believes that the amount of newspaper advertising (x) significantly affects sales. He randomly selects 7 days of data (n=7) consisting of daily grocery store sales (y, in thousands of dollars) and advertising expenditures (x, in thousands of dollars). The Excel...

  • Please answer 24 and 26 only A).22 B).08 24) Data were collected on monthly sales revenues...

    Please answer 24 and 26 only A).22 B).08 24) Data were collected on monthly sales revenues (in $1000s) and monthly advertising expenditures (51005) fora sample of drug sample of drug stores. The regression line relating revenues () to advertising expenditure (X) is estimated to 3+ 9.00x. The correct interpretation of the slope is that for each additional spent on advertising, predicted sales revenue decreases by $9000. be y =-48. A) $100 B) $1 spent on advertising, predicted sales revenue increases...

  • A regression model relating 2, number of salespersons at a branch office, to y, annual sales...

    A regression model relating 2, number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following computer output from a regression analysis of the data. Where Miotal = 30. 0 ANOVA 0 MSF Significance F SS 6361.5 Regression Residual Total 8844.6 P-value 85.0 5.418 Coefficients Standard Error Stat Intercept 10.553 Number of 43.0 Salespersons a. Write the estimated regression equation (to whole number). y= + b. Compute the F statistic...

  • Online Store Monthly E-commerce Sales (in 1000 s) Online Advertising Dollars (1000 s) 1330 670 ||950...

    Online Store Monthly E-commerce Sales (in 1000 s) Online Advertising Dollars (1000 s) 1330 670 ||950 4.5 Il0.5 1560 |2.0 380 ||1.5 Note: this was a real data, but I changed some of the numbers to make your MANUAL computations easier. 1. Identify the most appropriate/logical Dependent and Independent variables for this study. 2. Is the linear relationship between the Dependent and Independent variables significant at a=0.05? Use both the global and individual tests to answer the questions. Show all...

  • The tables below shows the results of a multiple linear regression analysis relating the sale price...

    The tables below shows the results of a multiple linear regression analysis relating the sale price y of a house (in dollars) versus LandVal (in dollars), Improvement (in dollars) and Area (in square feet): MS Source DF 877,967292656 46.66 100,349 6,272 978,316 0.00001 Regression 3 Residual16 Total 19 Predictor CoeffStd. ErrorT-valueP-value Intercept 1470 5746 0.26 0801 LandVal08145 0.5122 1.59 Improvement 0.8204 0.2112 3.88 2.05 0.131 0.001 Area 13.529 6.856 0.057 At alpha, a - 0.01 we can say that the...

  • A real estate research firm has developed a regression model relating list price (Y in 1,000)...

    A real estate research firm has developed a regression model relating list price (Y in 1,000) with two independent variables. The two independent variables are number of bedrooms and size of the property. Part of the regression results are shown below. ANOVA MS Regression 256881.37 128440.68 Residual 42 726699.96 17302.38 Coefficients Standard Error Star Intercept 54.298 # Bedrooms 53.634 71.326 5.271 33.630 Acres 21.458 1. What has been the sample size? (2 Points) 2. What is the value of the...

  • 3. You work for Mut the Custard, a frozen custard company. You’ve collected data on monthly...

    3. You work for Mut the Custard, a frozen custard company. You’ve collected data on monthly sales (S, number of regular-sized frozen custards per month) the price of your regular-sized frozen custard (P, in dollars), and the population size in the different cities in which your company operates (N, number of people; you currently only have one establishment in each city). You estimate the following regression model: S = a + bP + cN. In your regressions, you usually look...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT