Question: 1.Using Excel generate a simple regression model with Y as the dependent variable and X1 and X2 as the independent variables in the attached spreadsheet

1.Using Excel generate a simple regression model with Y as the dependent variable and X1 and X2 as the independent variables in the attached spreadsheet.

a.Write the following from the output:

Intercept:

Coefficients of Independent variable:

R-square:

Significance F:

b.Based on the model generated, forecast profits for a firm with X1= Based on the model generated, forecast profits for a firm with x1=250 and X2=100.

Evaluate the predictability of the model using explanatory language that someone who does not have experience with statistics or regression could understand to make informed business decisions, i.e., Interpret R2, F-test and t-tests.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Hello, please see attach and due dates. Please let me know if you're able to do this. Part A: Exploratory Data Analysis Preparation Open the files for the Course Project and the data set. For each of...

do not plaigiarize Preparation Open the files for the Course Project and the data set. For each of the five variables, process, organize, present and summarize the data. Analyze each variable by...

Project C: Regression and Correlation Analysis Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and...

48 36 46 47 44 49 35 46 44 39 48 42 45 54 43 44 34 44 40 51 41 45 52 39 41 45 46 47 42 45 44 50 46 53 39 39 48 46 43 44 42 39 49 41 42 39 37 46 45 44 50 39 43 45 42 168 131 162 183 177 181 123 169...

Direction: Select the letter of the most correct response for multiple choice problems. Show work for problems 19 and 20. Show work for non multiple question. 1. In a multiple regression problem...

Q6. (SIMPLE LINEAR REGRESSION) X4 = % of 18 to 24 year-olds in college The data for this question are provided below and are for each small American cities. Take Y as the dependent variable, and X1 -...

The data for this question are for each 30 stores of a grocery supermarket in U.K. The variables (Y, X1 to X5) are as follows Y = annual net sales (000s) X1 = area in sq. ft. (1000) X2 = inventory...

A micro economist wants to determine how corporate sales are influenced by capital and wage. She collect the data and produced the following regression output (Table 1) Regression Analysis R 0.689...

1 Understanding Regression Part 2 - Multiple Regression By Dr. Ardith Baker Oral Roberts University In the Part 1 paper, we explored simple linear regression with respect to understanding the basic...

Create charts to better understand data sets. For cross-sectional data, use a scatter chart. For time series data, use a line chart. Linear y = a + bx Logarithmic y = ln(x) Polynomial (2nd order) y =...

Nhia and Maya are each 50% owners (capital & profit/loss interest) of NM Partnership. Nhia contributed land (FMV = $100,000; AB = $10,000) to the partnership in exchange for her 50% interest, and...

4. Petrol station very near a football stadium has a pay car parks where the owner makes lots of money on sport league season. Last year it charged $4.00 per car and parked 1000 cars. This year it...

Question 2 : Does John s suggestion help PowerQuest to maximize shareholder value? Why or Why not?

Brazil Ltd has receivables of $ 6 5 , 0 0 0 , furniture totaling $ 2 0 5 , 0 0 0 and cash of $ 5 2 , 0 0 0 . The business has a $ 1 0 9 , 0 0 0 bill payable and owes $ 8 1 , 0 0 0 on account. How...