databases exercise and need the explanation and answer to help me learn.
Relationship Significance Testing Lab and Homework Assignment
Instructions:
The assignment deliverable is to submit your completed Excel Workbook with the Relationship Significance Testing tasks completed as a SINGLE EXCEL FILE.
Continue working on the same “Housing Market Dataset” workbook from the “Bivariate Exploratory Analysis” Lab and HW. We will continue to build on this workbook for all Lab, Homework, Midterm, and Final Project objectives.
Save your work as you go and ultimately make sure you save it in your cloud storage environment (Microsoft OneDrive or Sharepoint, or GoogleDrive). My computer crashed is not a valid excuse for late or incomplete work.
Check off each of the tasks as you complete them. It is expected that the student has attended/or watched and attempted the lecture tutorials in order to understand how to complete the assignment tasks. Save and rename your Excel workbook as “LastName Firstname – Relationship Significance Testing Lab and Homework.”
Submit your ASSIGNMENT SUBMISSION FORM AND EXCEL WORKBOOK to the “Assignments” folder in D2L (Desire 2 Learn).
**Points will be deducted for failure to follow all instructions, regardless of how trivial you think they are.
Please ensure that:
You are only submitting one Excel workbook with all tasks completed with the instructed worksheet tabs.
You have named your submission according to the instruction above.
Your worksheets are organized and easy to follow.
Objective 1: Bivariate 2 Quantitative Relationship Testing
Perform Testing in “9 – 2 Quant Reg Test” worksheet.
State both the Null and Alternative Hypothesis
Perform the Test: Go to the Data Analysis Tool Pak and perform a simple Linear Regression Test between each independent quantitative variable and sale price (these are the same variables you created scatterplots with in the bivariate exploratory analysis lab. Make sure the dependent variables is in the y-range and the independent variable is in the x-range. Also make sure you select the appropriate options from the testing menu. (Labels, Output Range, and Residual Plots)
Clean up the testing output: Organize output neatly, round decimals, etc..
Interpret the important criteria for each relationship pair: Multiple R, R-Squared, Residual Plot
Interpret the p-value and make your hypothesis conclusions at the 5% significance level for each relationship pair.
Objective 2: Bivariate 1 Categorical 1 Quantitative ANOVA and T-Tests
Perform Testing in a new worksheet called “10 – 1 Cat 1 Quant Tests” worksheet.
Test 1:
State both the Null and Alternative Hypothesis
Perform the Test: Go to the Data Analysis Tool Pak and perform an ANOVA test between Foundation and Sale Price. Make sure you are using the reformatted data (from your stratified analysis). Also make sure you select the appropriate options from the testing menu. (Labels, Alpha = 0.05, and Output Range)
Clean up the testing output: Organize output neatly, round decimals, etc..
Interpret the p-value and make your hypothesis conclusions at the 5% significance level.
Follow up the ANOVA with pairwise t-test (assuming unequal variance), to see if there are significant differences between all the categories, or just certain ones. Indicate weather there is a significant difference for each pair based on the p-value. (i.e. – 3 pairwise tests)
t-test between PConc and CBlock
t-test between PConc and Slab
t-test between Slab and CBlock
Test 2:
State both the Null and Alternative Hypothesis
Perform the Test: Go to the Data Analysis Tool Pak and perform ANOVA assuming unequal variances between House Style and Sale Price. Make sure you are using the reformatted data. Also make sure you select the appropriate options from the testing menu. (Labels, Mean Difference = 0, Alpha = 0.05, and Output Range)
Clean up the testing output: Organize output neatly, round decimals, etc..
Interpret the p-value and make your hypothesis conclusions at the 5% significance level.
Requirements: Required Length