Graded Lab Monday Nov 9
- Perform Linear Regression Analysis for HarvestRain and
Age independent variables.
- Document Results here
- Compare R^2 values. Which model is the best model?
- If time permits: Perform Linear Regression Analysis for WinterRain and FrancePop variables and compare R^2 for all 5
independent variables. Which model is the best model?
Detailed Instructions
Analysis for HarvestRain
- Open your Training application
- COPY AGST_Training_Summary Sheet
- Rename it - HarvestRain_Training_Summary
- The following objects must be in the Sheet:
- Strainght Table
- Statistics Box with Average, Min and Max values
- Scatter Chart
- Text Object with R^2 value
- Combo chart showing actual price as bar chart and predicted price as line chart
- In StraightIn ALL expressions change AGST to HarvestRain
- In Statistics box, change AGST to HarvestRain
- In Scatter plot, change first expression to be HarvestRain
- In Combo Chart, in the Expression (0.6351*Only(AGST)-3.4178)
change AGST to Harvest Rain, 0.6351 to the Linear Regression Coefficient A you found in Straight Table, -3.4178 to the Linear
Regression Coefficient B you found in the straight table. (Alternatively, you can write the following expression:
$(=LINEST_M(Price, HarvestRain))*Only(HarvestRain)+$(=LINEST_B(Price, HarvestRain))
- Open the Word Summary File
- Document Linear Regression Formula and R2 for HarvestRain variable.
- Save the file and close it
- Open Testing application
- Copy AGST_Testing_Summary Sheet
- Rename it to HarvestRain_Testing_Summary
- The following objects must be on the Sheet:
- Combo Chart showing actual price as bar chart and predicted price as line chart
- Straight Table showing information for 1979 and 1980 ONLY
- In ALL expressions in ALL objects, replace AGST with HarvestRain and change linear regression coefficients.
Pay Attention, in this
application you MUST write numeric values for Linear Regression Coefficients. You cannot use
LINEST_M and LINEST_B functions. Copy the numbers from the Word file
- Save the file and close it
Perform Similar Analysis for Age
- Document Results here
- Compare R^2 values. Which model is the best model?
- Write your conclusion and explanation in the Word file.
- If time permits: Perform Linear Regression Analysis for WinterRain and FrancePop variables and compare R^2 for all 5
independent variables. Which model is the best model?
- Submit: Training and Testing application files and Word file with
Summary of results and conclusion