Question NAME______________ Major:___________

NAME______________ Major:_____________________

PART A). Excel Project Instruction

To answer these questions, you first need to look at the attached Excel File and, after some required manipulations, which will entail using Excel’s Formula and other functions, you are to run a model using Excel’s Multiple Regression feature.

You are to type your answers here in MS Word and, wherever needed, copy & paste the information (Numbers or graphs) form Excel print outs of the Regression Results to this Word File.

The First part has to do with you manipulate the data and run the regression and saved that as an Excel File and turn it in; you will see below what operations you should perform in Excel.

Save this file as:

“Excel Output-Your Name” Example: Excel Project- Bart Simpson

and deliver them via Blackboard. Do not forget to Include, on the top of Excel output, YOUR NAME and YOUR MAJOR.

The second part, Part B (A MS Word file) contains the regression Questions). It should be typed, saved and submitted via Bb.

Save This File as:

“Excel Project Answers- Your Name”

Each Part (Parts A & B), have 100 pints for a total of 200 points for this Excel Project.

The attached file (Excel Project data) is a sample data where Y is modeled as a function of X₁, X_2,X_3,and X_4. That is:

y = ƒ(X₁, X_2, X_3,X₄)_.

The linear model specified is as follows:

y = ?o + ?₁X₁ + ?₂X₂ + ?₃X₃ +?₃X₄ + ?

Based on the sample data, you are to Run a Multiple Regression model in Excel to estimate the values of the parameters (b₀ , b_1 ,b_{2 ,}b₃ and b₄) for the following Estimator equation:

?=b? +b₁X₁ +b₂X₂ +b₃X₃ +b₃X₄

PART A)–MANIPULATION OF THE EXCEL DATA SET (100 Points)

A1.First of all, you see that, instead of the familiar COLUMNS of the independent variables, here, you have ROWS of them. You are to use Excel’s Transpose feature to create a data set with columns, instead of rows (You probably know that Excel really does not need the transpose to run Regression Model, but I AM ASKING YOU to do it!)

A2. As you can see in the attached Excel file, you do not have a column for the fourth independent variable in the model above (X₄).

YOU are to create that column next to column for column X₃. Now, Variable X₄ , is the Natural Logarithm (Base e) of the Mean of columns X₂ and X_3,. Then get the Natural Log of that Mean You are to create this column, using appropriate Excel functions.

A3. After creating the column for X_4, you run the Multiple Regression where y is your dependent variable and X₁, X_2, X_3,and X_4bare your Dependent variables. Ask for Residuals, and residual plots and Normal . Probability Plot.

A5. YOU should also create the Correlation Matrix of the independent variables in this NEW data set using Excel’s relevant statistical function. You have questions below that will require use of that matrix.

A6. You should know how to calculate the Durbin-Watson Statistic (Formula below as well as in Formula sheet) and you should also know for what purpose Durbin-Watson Statistic and Correlation Matrix is used. You are asked to calculate the Durbin-Watson statistics. Here is the formula for D-W Test Statistics (Also included in the Formula Sheet 2):

Durbin-Watson Test Statistics

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.