This assignment requires you to run the ‘Regression’ analysis tool which can be found under DATA/Data Analysis. The file contains data for the dependent variable, y, and 3 independent variable, x 1, x2 and x3. You are to
run regression analysis on this data set. Once the output has been created, you are to: format all values in the output to 4 decimal places except for ‘Observations’ and ‘df ‘
make certain that columns are wide enough so that all no words in the output are cut-of
shade the cell containing the proportion of the total variation in Y explained by the model in
yellow
shade the cells containing the best estimates of the efects that the x’s have on y in orange
shade the cell containing the test statistic for testing whether there is a negative linear
relationship between y and x2 in green
shade the cell containing the p-value for testing whether there is a linear relationship between Y
and x1 in purple
shade the cell containing the p-value for testing the usefulness of the model in blue
ScholarMatic | 24/7 Homework Help
ScholarMatic Will Help You Write Your Essays and Term Papers
Answered » You can buy a ready-made answer or pick a professional tutor to order an original one.
202 Excel Assignment 2 Summer, 2017
HOME TO CERTIFIED WRITERS

Why Place An Order With Us?
- Certified Editors
- 24/7 Customer Support
- Profesional Research
- Easy to Use System Interface
- Student Friendly Pricing
Have a similar question?
ScholarMatic: Get Started
Assignment Writing Service
Feel safe and secure when placing an order on our portal!
Fruitful cooperation begins with solid guarantees, and we are professional enough to promise perfect results. Let’s get it started!




