Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 26 (3 points) You are interested in using regression analysis to predict your firm's monthly profits using the total number of stores the firm

image text in transcribed

Question 26 (3 points) You are interested in using regression analysis to predict your firm's monthly profits using the total number of stores the firm has and the amount they spend on advertising. You use monthly data for the past ten years to obtain the following estimates for the two models below. Please note the variable descriptions for the units each variable is measured in. Variable Descriptions In(profit): the natural log of the firm's total monthly profits. Profit: the firm's total monthly profits measured in $1,000s. Stores: the total number of stores the firm has operating. Advertising: the total amount the firm spends on advertising each month measured in dollars. Model 1: In(Profit) = 3.65 + 0.16(Stores) + 0.00009(Advertising) Goodness of Fit Measures from Excel: R2 = 0.29, Adjusted R2 = 0.28, Se = 1.79 Model 2: Profit = 852.03 + 236.25(Stores) + 0.00025(Advertising) Goodness of Fit Measures from Excel: R2 = 0.26, Adjusted R2 = 0.23, Se = 105.25 For model 1, suppose you go through the necessary steps in Excel and find a correlation (r) between the predicted profits and the actual profits to be 0.52. Based on the information above, which of the following statements is TRUE? Question 26 (3 points) You are interested in using regression analysis to predict your firm's monthly profits using the total number of stores the firm has and the amount they spend on advertising. You use monthly data for the past ten years to obtain the following estimates for the two models below. Please note the variable descriptions for the units each variable is measured in. Variable Descriptions In(profit): the natural log of the firm's total monthly profits. Profit: the firm's total monthly profits measured in $1,000s. Stores: the total number of stores the firm has operating. Advertising: the total amount the firm spends on advertising each month measured in dollars. Model 1: In(Profit) = 3.65 + 0.16(Stores) + 0.00009(Advertising) Goodness of Fit Measures from Excel: R2 = 0.29, Adjusted R2 = 0.28, Se = 1.79 Model 2: Profit = 852.03 + 236.25(Stores) + 0.00025(Advertising) Goodness of Fit Measures from Excel: R2 = 0.26, Adjusted R2 = 0.23, Se = 105.25 For model 1, suppose you go through the necessary steps in Excel and find a correlation (r) between the predicted profits and the actual profits to be 0.52. Based on the information above, which of the following statements is TRUE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

=+1. How should emotional intelligence be assessed?

Answered: 1 week ago