KSU Databases Unique Housing ID for Observation Identification Project

Having Trouble Meeting Your Deadline?

Get your assignment on KSU Databases Unique Housing ID for Observation Identification Project completed on time. avoid delay and – ORDER NOW

Do My Paper

Relationship Significance Testing Lab and Homework Assignment

Objective 1: Bivariate 2 Quantitative Relationship Testing

Perform Testing in “9 – 2 Quant Reg Test” worksheet.

1. State both the Null and Alternative Hypothesis
2. 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)
3. Clean up the testing output: Organize output neatly, round decimals, etc..
4. Interpret the important criteria for each relationship pair: Multiple R, R-Squared, Residual Plot
5. 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:

1. State both the Null and Alternative Hypothesis
2. 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)
3. Clean up the testing output: Organize output neatly, round decimals, etc..
4. Interpret the p-value and make your hypothesis conclusions at the 5% significance level.
5. 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)
   1. t-test between PConc and CBlock
   2. t-test between PConc and Slab
   3. t-test between Slab and CBlock

Test 2:

1. State both the Null and Alternative Hypothesis
2. 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)
3. Clean up the testing output: Organize output neatly, round decimals, etc..
4. Interpret the p-value and make your hypothesis conclusions at the 5% significance level.