Satterfield Seth - Submission Form – Bivariate Exploratory Analysis Lab + HW

.docx

School

Kennesaw State University *

*We aren’t endorsed by this school

Course

NOT SURE

Subject

Industrial Engineering

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by MajorDeer2792

Name: Seth Satterfield Bivariate Data Analysis Lab + HW SUBMISSION FORM Please organize your work in the appropriate space below. Do not change the order, this is to help expedite the grading process and get your feedback to you as quickly as possible. STUDENTS MUST SUBMIT BOTH THIS WORD DOCUMENT AND THE EXCEL WORKBOOK FOR CREDIT. No credit will be awarded if the Excel file is not submitted. Analysis in the workbook and the word document should be consistent. ALL SCREEN GRABS SHOULD BE NEATLY FORMATTED, ORGANIZED, AND PASTED AS PICTURES IN THE WORD DOCUMENT. 1. Paste Neatly Formatted Bivariate 2 Quant Tables and Graphs Below: Correlation Matrix: Living Area nry Veneer Full Baths ge Car Capa Sale Price Living Area 1 Masonry V 0.362994 1 Full Baths 0.469838 0.248511 1 Garage Car 0.456984 0.348025 0.439404 1 Sale Price 0.694537 0.490779 0.576983 0.644035 1 Scatterplot 1: R² = 0.4824 $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 0 500 1000 1500 2000 2500 3000 3500 4000 Sale Price Living Area (sqft) Scatterplot of Sale Price by Living Area (n=1367) Relationship Interpretation 1: There appears to be a strong positive relationship between Sale Price and Living Area. The points are forming a strong pattern. The resulting coefficient of determination is 0.4824. Scatterplot 2: Relationship Interpretation 2: There appears to be a strong 1

R² = 0.2409 0 100000 200000 300000 400000 500000 600000 0 200 400 600 800 1000 1200 Sale Price Masonry Living Area (sqft) Scatterplot of Sale Price by Masonry Living Area (n=1367) positive relationship between Sale Price and Masonry Living Area. The points are forming a strong pattern. The resulting coefficient of determination is 0.2409. Scatterplot 3: 0 1 2 3 4 5 0 100000 200000 300000 400000 500000 600000 R² = 0.33 Scatterplot of Sale Price by Full Bathrooms (n=1367) Full Bathrooms Sale Price Relationship Interpretation 3: There appears to be a strong positive relationship between Sale Price and Full Bathrooms. The points are forming a strong pattern. The resulting coefficient of determination is 0.3329. Scatterplot 4: Relationship Interpretation 4: There appears to be a strong positive relationship between Sale Price and Garage Car Capacity. The points are forming a strong pattern. The resulting coefficient of determination is 0.4148. 2

R² = 0.4148 0 100000 200000 300000 400000 500000 600000 0 1 2 3 4 Sale Price Garage Car Capacity Scatterplot of Sale Price by Garage Car Capacity (n=1367) 2. Paste Neatly Formatted Bivariate 1 Cat 1 Quant Tables and Graphs Below: Analysis 1: Stratified Table Sample Statistics Fair Below Average Average Above Average Good Very Good Excellent Very Excellent Mean 115587.5 127432.6866 138613.1926 164306.7781 207613.3052 269622.8907 359209.4643 377925.714 Median 115587.5 125000 135900 161000 200570.5 260116 360000 43878 Standard Deviation 14972.98609 22718.99672 22491.74869 35236.57907 42650.815 59239.46499 73355.14297 103982.638 Range 21175 128500 152000 190000 267070 263870 350000 27525 IQR 10587.5 29546 23650 43200 51200 78700 94539.25 12597 Q1 110293.75 109454 125000 140000 178000 226750 312272.5 32750 Q3 120881.25 139000 148650 183200 229200 305450 406811.75 45347 Minimum 105000 100000 100000 100000 116900 161000 150000 18475 Maximum 126175 228500 252000 290000 383970 424870 500000 46000 Sum 231175 8537990 52534400 59971974 63944898 49340989 20115730 264548 Sample Size 2 67 379 365 308 183 56 Table 9: Decriptive Sample Statistics For Sale Price from Overall Quality Analysis 1: Side-by-Side Boxplots 3

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