Instructions - Relationship Significance Testing Lab + HW

docx

School

Kennesaw State University *

*We aren’t endorsed by this school

Course

NOT SURE

Subject

Management

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by MajorDeer2792

1 Relationship Significance Testing Lab + HW Assignment Instructions: 1. Use the NEW provided Excel workbook, “Housing Market Dataset Spring 2024 – POST MIDTERM DATA ”. This is to ensure everyone has a fresh start place regardless of past performance. 2. Save and rename your Excel workbook as “LastName Firstname - Excel Workbook – Relationship Significance Testing Lab + HW ”. 3. Organize your work in the provided assignment submission form , “Submission Form – Relationship Significance Testing Lab + HW ”. 4. Save and rename your submission form as “LastName Firstname - Submission Form – Relationship Significance Testing Lab + HW ”. 5. Submit your Excel workbook AND Submission Form to the “Assignments” folder in D2L – ON OR BEFORE THE DUE DATE. **Points will be deducted for failure to follow all instructions, regardless of how trivial you think they are. Please ensure that: a. You 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. b. You have named your submissions according to the instruction above. c. You check off each of the tasks as you complete them. It is expected that the student has attended class and/or watched and attempted the lecture tutorials in order to understand how to complete the assignment tasks. 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.

2 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.

3 Grading Rubric: Grade Item Points Possible Grading Criteria Regression Test (4 Tests) 8 points each x 4 Tests = 32 Points Regression Test 1. Dep. Charges: Y-Range 2. Ind. Age: X-Range 3. Labels 4. Residual Plots ) Interpretation 1. Correlation Coefficient - R 2. Coefficient of Determination - R2 3. Residual Plots 4. P-value and Conclusion Overall Formatting and Completeness 1. Neatly Organize Output 2. Spelling and Grammar 3. Sentence Structure/Completeness 4. Organized Worksheet Regression Hypotheses and Organization 8 Points Correct Hypothesis Statement (4 Regression Tests) Spelling, Grammar, Completeness, and Overall Organization ANOVA Test 8 Points Each x 2 Test = 16 points ANOVA and Interpretation 1. Tables 2. Labels 3. P-value 4. Conclusion Hypothesis Statements and Overall Formatting and Completeness 1. Correct Hypotheses 2. Spelling and Grammar 3. Sentence Structure/Completeness 4. Neatly Organize Output T Test 4 Points Each x 3 Tests = 12 points t - Test and Interpretation 1. Tables 2. Labels 3. P-value 4. Conclusion Overall Workbook Formatting 6 points Document Naming Convention (2pts) Worksheets Neatly Organized/Easy to Grade (2 Quant and 1 Cat 1 Quant) (2pts each) Total Points Possible 74 points Don’t forget: Save your Excel workbook as “LastName Firstname – Relationship Significance Testing Assignment” and submit it to the “Assignments” folder in D2L by or before the due date.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

BUS515 DB 5.docx

TEST BANK for Entrepreneurship, 1st Canadian Edition.pdf

Organizational Effectiveness Paper.docx

Presentations Take-Away.docx

StrategicPlanning.docx

Part 2 Report Grading Rubric (2).docx

Chapter 3 Meeting Summary.docx

Organizational Development ASSIGNMENT .docx

ResponseSummary.pdf

Individual Case1 1207.docx

Unit 2 Discussion.docx

1-4 Video Check-In- Learner-Instructor Connect.docx

Recommended textbooks for you

Purchasing and Supply Chain Management

Operations Management

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Cengage Learning

Practical Management Science

Operations Management

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:Cengage,

Marketing

ISBN:9780357033791

Author:Pride, William M

Publisher:South Western Educational Publishing

MARKETING 2018

Marketing

ISBN:9780357033753

Author:Pride

Publisher:CENGAGE L

SEE MORE TEXTBOOKS

Recommended textbooks for you

Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L