Frequency Distribution - Quantitative Listing Price lower upper 500,000 600,000 700,000 800,000 900,000 1,000,000 1,100,000 1,200,000 1,300,000 1,400,000 1,500,000 1,600,000 1,700,000 1,800,000 1,900,000 2,000,000 2,100,000 2,200,000 2,300,000 2,400,000 2,500,000 2,600,000 2,700,000 2,800,000 2,900,000 3,000,000 3,100,000 3,200,000 3,300,000 3,400,000 3,500,000 3,600,000 3,700,000 3,800,000 3,900,000 4,000,000 4,100,000 4,200,000 4,300,000 4,400,000 < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < < 600,000 700,000 800,000 900,000 1,000,000 1,100,000 1,200,000 1,300,000 1,400,000 1,500,000 1,600,000 1,700,000 1,800,000 1,900,000 2,000,000 2,100,000 2,200,000 2,300,000 2,400,000 2,500,000 2,600,000 2,700,000 2,800,000 2,900,000 3,000,000 3,100,000 3,200,000 3,300,000 3,400,000 3,500,000 3,600,000 3,700,000 3,800,000 3,900,000 4,000,000 4,100,000 4,200,000 4,300,000 4,400,000 4,500,000 midpoint 550,000 650,000 750,000 850,000 950,000 1,050,000 1,150,000 1,250,000 1,350,000 1,450,000 1,550,000 1,650,000 1,750,000 1,850,000 1,950,000 2,050,000 2,150,000 2,250,000 2,350,000 2,450,000 2,550,000 2,650,000 2,750,000 2,850,000 2,950,000 3,050,000 3,150,000 3,250,000 3,350,000 3,450,000 3,550,000 3,650,000 3,750,000 3,850,000 3,950,000 4,050,000 4,150,000 4,250,000 4,350,000 4,450,000 Histogram 35 30 25 20 Percent 15 10 5 0 width 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 frequency 29 29 18 7 2 2 3 1 4 1 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 100 percent 29.0 29.0 18.0 7.0 2.0 2.0 3.0 1.0 4.0 1.0 0.0 0.0 0.0 0.0 1.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 100.0 cumulative frequency percent 29 29.0 58 58.0 76 76.0 83 83.0 85 85.0 87 87.0 90 90.0 91 91.0 95 95.0 96 96.0 96 96.0 96 96.0 96 96.0 96 96.0 97 97.0 97 97.0 98 98.0 98 98.0 98 98.0 98 98.0 98 98.0 98 98.0 98 98.0 98 98.0 98 98.0 98 98.0 98 98.0 98 98.0 98 98.0 99 99.0 99 99.0 99 99.0 99 99.0 99 99.0 99 99.0 99 99.0 99 99.0 99 99.0 99 99.0 100 100.0 25 20 Percent 15 10 5 0 Listing Price Century 21. Chula Vista Listings Listing Price Square Footage Property Address 2920 Gate Five Vista, Ca 91914 Chula 2860 Gate Eight Vista, Ca 91914 Chula 874 Carmona Vista, Ca 91910 Chula No. Bedrooms $4,499,900.00 9200 6 $3,499,900.00 8263 8 $2,120,000.00 5110 5 2902 Gate Fourteen Chula Vista, Ca 91914 $1,950,000.00 5442 6 3028 Nature View Ct. Chula Vista, Ca 91914 $1,499,900.00 4995 6 361 Bryan Pt. Vista, Ca 91914 $1,350,000.00 4287 5 $1,348,300.00 4212 6 1871 Camino Mojave Chula Vista, Ca 91914 $1,300,000.00 5143 5 221 Dovary Rd. Vista, Ca 91910 $1,300,000.00 3750 5 $1,250,000.00 6274 6 $1,199,000.00 4301 7 $1,190,000.00 4278 5 2823 Sutter Ridge Dr. Chula Vista, Ca 91914 $1,125,000.00 4288 6 817 Dorothy Street Chula Vista, Ca 91910 $1,099,000.00 4746 2 1145 Old Janal Ranch Rd. Chula Vista, Ca 9191 $1,089,000.00 4278 6 1036 Mountain Ash Ave. Chula Vista, Ca 91914 $925,000.00 3739 6 2555 Crooked Trail Rd. Chula Vista, Ca 91914 $910,000.00 3617 6 831 Shadow Ridge Pl Chula Vista, Ca 91914 $885,000.00 3657 6 795 Hawks View Chula Vista, Ca 91914 $850,000.00 3498 5 568 Bent Trl Chula Vista, Ca 91914 $839,900.00 3341 6 816 Middle Fork Pl. Chula Vista, Ca 91914 $839,900.00 3422 5 429 Milagrosa Vista, Ca 91910 Chula Chula Chula 2819 Shenandoah Chula Vista, Ca 91914 893 Aspen Glen Vista, Ca 9191 Chula 2822 Lake Crest Ct. Vista, Ca 9195 Chula 2715 Joshua Creek Rd. Chula Vista, Ca 91914 $824,900.00 3696 6 2514 King Creek Cir Chula Vista, Ca 91915 $820,000.00 3778 5 539 Moya Pl. Chula Vista, Ca 91910 $810,000.00 3566 6 765 Crooked Path Pl Chula Vista, Ca 91914 $799,900.00 3121 4 $789,900.00 4259 5 1446 Old Janal Ranch Rd. Chula Vista, Ca 91915 $784,900.00 3534 5 2424 S Trail Ct. Chula Vista, Ca 91914 $775,000.00 3031 5 844 Shadow Ridge Pl. Chula Vista, Ca 91914 $775,000.00 3290 5 $774,990.00 3374 5 $768,000.00 3151 6 $759,000.00 3200 5 1814 Meeks Bay Chula Vista, Ca 91913 $750,000.00 2950 5 1059 Mountain Ash Chula Vista, Ca 91914 $750,000.00 3739 5 1195 Misty Creek Ct. Chula Vista, Ca 91913 $749,000.00 3682 6 801 Calle Lagasca Chula Vista, Ca 91910 $749,000.00 3136 5 1425 South Creekside Chula Vista, Ca 91915 $749,000.00 3200 4 1470 Old Janal Ranch Rd Chula Vista, Ca 91915 $735,000.00 2944 4 1217 Farmerville St. Chula Vista, Ca 91913 $729,000.00 3694 6 1833 Harrils Mill Ave. Chula Vista, Ca 91913 $729,000.00 3374 5 1477 Tridle Chula Vista, Ca 91911 $720,000.00 3334 4 1168 Tenaya Lake Chula Vista, Ca 91913 $714,900.00 3087 5 1590 Trailwood Ave. Chula Vista, Ca 91913 $699,900.00 3216 6 917 Chesapeake Vista, Ca 91914 1812 Lagrange Rd. Vista, Ca 91913 Chula Chula 1058 Edgewood Place Chula Vista, Ca 91913 1454 Sugar Pine Pl Vista, Ca 91915 Chula 1032 Red Granite Rd. Chula Vista, Ca 91913 $699,900.00 3837 4 834 Calle Lagasca Chula Vista, Ca 91910 $699,900.00 3519 5 2800 Savannah Court Chula Vista, Ca 91914 $699,000.00 3047 5 820 Middle Fork Pl Chula Vista, Ca 91914 $699,000.00 3856 5 2708 Valley Creek Cir Chula Vista, Ca 91914 $699,000.00 3191 5 1064 Moonstone Pl Chula Vista, Ca 91913 $684,000.00 3087 4 1486 Old Janal Ranch Chula Vista, Ca 91915 $675,000.00 2358 4 1435 Trailwood Ave Chula Vista, Ca 91913 $672,000.00 3157 5 671 Floyd Chula Vista, Ca 91910 $669,000.00 2898 5 952 Isom Chula Vista, Ca 91911 $669,000.00 3334 5 749 N Valley View Dr. Chula Vista, Ca 91914 $655,000.00 2429 4 755 N Fox Run Place Chula Vista, Ca 91914 $650,000.00 3628 6 2145 Plaza Kadie Chula Vista, Ca 91914 $649,900.00 2782 5 1168 Benecia Chula Vista, Ca 91913 $649,000.00 2968 5 1247 Granite Springs Dr. Chula Vista, Ca91915 $649,000.00 2492 5 63 Las Flores Chula Vista, Ca 91910 $642,000.00 2332 4 1737 Bouquet Canyon Rd. Chula Vista, Ca 91913 $639,000.00 2600 4 2594 Saddleback Rd. Chula Vista, Ca 91914 $639,000.00 2447 5 1767 Bramblewood Ct. Chula Vista, Ca 91913 $639,000.00 2900 4 1752 Sage Tree Ct. Chula Vista, Ca 91913 $630,000.00 3235 4 1149 Wind River Chula Vista, Ca 91913 $625,000.00 2462 5 1721 Ravenrock Court Chula Vista, Ca 91913 $619,900.00 2454 5 2372 Eastridge Loop Chula Vista, Ca 91915 $619,000.00 2162 5 910 Loma Vw Chula Vista, Ca 91910 $619,000.00 2143 4 2453 Ponte Vedra Chula Vista, Ca 91915 $619,000.00 2382 6 2122 Corte Condesa Chula Vista, Ca 91914 $609,900.00 2486 5 $605,000.00 2808 4 2594 Flagstaff Ct. Chula Vista, Ca 91914 $605,000.00 2215 4 652 E J Chula Vista, Ca 91910 $599,990.00 2554 4 2122 Corte Condesa Chula Vista, Ca 91914 $599,900.00 2486 5 1810 Casa Morro St. Chula Vista, Ca 91915 $599,000.00 2225 4 1525 Amador Chula Vista, Ca 91913 $599,000.00 2090 5 678 Felino Way Chula Vista, Ca 91910 $598,000.00 2376 6 2576 Green Valley Rd. Chula Vista, Ca 91915 $595,500.00 2564 4 $595,000.00 2491 4 1246 Farmerville St. Chula Vista, Ca 91913 $594,000.00 2623 4 1463 Horn Canyon Ave. Chula Vista, Ca 91915 $589,000.00 2053 5 968 Camino La Paz Chula Vista, Ca 91910 $585,000.00 2137 4 979 Strawberry Crk Chula Vista, Ca 91913 $579,900.00 2013 4 2396 Fairway Oaks Dr. Chula Vista, Ca 91915 $579,000.00 2353 4 11 Vista Dr. Chula Vista, Ca 91910 $579,000.00 2040 3 122 Corte Maria Ave. Chula Vista, Ca 91910 $575,000.00 1800 3 287 Eucalyptus court Chula Vista, Ca 91910 $575,000.00 2010 4 1536 Picket Fence Dr. Chula Vista, Ca 91915 $575,000.00 2233 4 1650 Shircliffe Vista, Ca 91913 1737 Picket Fence Vista, Ca 91915 Chula Chula 1331 Tierra Bonita Pl Chula Vista, Ca 91910 $569,900.00 2446 5 526 Kiley Rd Chula Vista, Ca 91910 $569,900.00 1968 4 1532 Cordelia St. Chula Vista, Ca 91913 $569,900.00 2100 4 968 Saint Germain Chula Vista, Ca 91913 $569,000.00 2315 5 1341 Carneros Valley St. Chula Vista, Ca 91913 $569,000.00 2123 4 1433 Oakpoint Ave. Chula Vista, Ca 91913 $560,000.00 2509 4 1431 Blackstone Ave. Chula Vista, Ca 91915 $559,900.00 2014 4 1610 Piedmont Chula Vista, Ca 91913 $559,900.00 1953 4 621 Prairie Chula Vista, Ca 91914 $559,000.00 1730 3 2641 Lightning Trail Ln Chula Vista, Ca 91915 $559,000.00 1856 4 614 Point Caiman Ct. Chula Vista, Ca 91911 $550,000.00 2099 4 1 N 2nd Ave. Chula Vista, Ca 91910 $549,900.00 1431 3 1095 Morgan Hill Dr. Chula Vista, Ca 91913 $549,900.00 2119 4 Mean Median Mode Standard deviation 827682.8 3161.17 673500 3039 749000 4278 537069.3590689 1206.5589944846 Chart Title 1% 1% 1% 1% 2% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 0% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1 9 17 25 33 41 49 57 65 73 81 89 97 2 10 18 26 34 42 50 58 66 74 82 90 98 3 11 19 27 35 43 51 59 67 75 83 91 99 4 12 20 28 36 44 52 60 68 76 84 92 100 5 13 21 29 37 45 53 61 69 77 85 93 6 14 22 30 38 46 54 62 70 78 86 94 7 15 23 31 39 47 55 63 71 79 87 95 8 16 24 32 40 48 56 64 72 80 88 96 Property Address Century 21. Chula Vista Listings Listing Price Square Footage No. Bedrooms 2920 Gate Five Chula Vista, Ca 91914 $4,499,900.00 9200 6 2860 Gate Eight Chula Vista, Ca 91914 $3,499,900.00 8263 8 874 Carmona Chula Vista, Ca 91910 $2,120,000.00 5110 5 2902 Gate Fourteen Chula Vista, Ca 91914 $1,950,000.00 5442 6 3028 Nature View Ct. Chula Vista, Ca 91914 $1,499,900.00 4995 6 361 Bryan Pt. Chula Vista, Ca 91914 $1,350,000.00 4287 5 429 Milagrosa Chula Vista, Ca 91910 $1,348,300.00 4212 6 1871 Camino Mojave Chula Vista, Ca 91914 $1,300,000.00 5143 5 221 Dovary Rd. Chula Vista, Ca 91910 $1,300,000.00 3750 5 2819 Shenandoah Chula Vista, Ca 91914 $1,250,000.00 6274 6 Mean $2,011,800.00 5667.6 816 Middle Fork Pl. Chula Vista, Ca 91914 $839,900.00 3422 5 2715 Joshua Creek Rd. Chula Vista, Ca 91914 $824,900.00 3696 6 2514 King Creek Cir Chula Vista, Ca 91915 $820,000.00 3778 5 539 Moya Pl. Chula Vista, Ca 91910 $810,000.00 3566 6 765 Crooked Path Pl Chula Vista, Ca 91914 $799,900.00 3121 4 917 Chesapeake Chula Vista, Ca 91914 $789,900.00 4259 5 1446 Old Janal Ranch Rd. Chula Vista, Ca 91915 $784,900.00 3534 5 2424 S Trail Ct. Chula Vista, Ca 91914 $775,000.00 3031 5 844 Shadow Ridge Pl. Chula Vista, Ca 91914 $775,000.00 3290 5 1812 Lagrange Rd. Chula Vista, Ca 91913 $774,990.00 3374 5 Mean $799,449.00 3507.1 1477 Tridle Chula Vista, Ca 91911 $720,000.00 3334 4 1168 Tenaya Lake Chula Vista, Ca 91913 $714,900.00 3087 5 1590 Trailwood Ave. Chula Vista, Ca 91913 $699,900.00 3216 6 1032 Red Granite Rd. Chula Vista, Ca 91913 $699,900.00 3837 4 834 Calle Lagasca Chula Vista, Ca 91910 $699,900.00 3519 5 2800 Savannah Court Chula Vista, Ca 91914 $699,000.00 3047 5 820 Middle Fork Pl Chula Vista, Ca 91914 $699,000.00 3856 5 2708 Valley Creek Cir Chula Vista, Ca 91914 $699,000.00 3191 5 1064 Moonstone Pl Chula Vista, Ca 91913 $684,000.00 3087 4 1486 Old Janal Ranch Chula Vista, Ca 91915 $675,000.00 2358 4 Mean $699,060.00 3253.2 2594 Saddleback Rd. Chula Vista, Ca 91914 $639,000.00 2447 5 1767 Bramblewood Ct. Chula Vista, Ca 91913 $639,000.00 2900 4 1752 Sage Tree Ct. Chula Vista, Ca 91913 $630,000.00 3235 4 1149 Wind River Chula Vista, Ca 91913 $625,000.00 2462 5 1721 Ravenrock Court Chula Vista, Ca 91913 $619,900.00 2454 5 2372 Eastridge Loop Chula Vista, Ca 91915 $619,000.00 2162 5 910 Loma Vw Chula Vista, Ca 91910 $619,000.00 2143 4 2453 Ponte Vedra Chula Vista, Ca 91915 $619,000.00 2382 6 2122 Corte Condesa Chula Vista, Ca 91914 $609,900.00 2486 5 1650 Shircliffe Chula Vista, Ca 91913 $605,000.00 2808 4 Mean $622,480.00 2547.9 968 Camino La Paz Chula Vista, Ca 91910 $585,000.00 2137 4 979 Strawberry Crk Chula Vista, Ca 91913 $579,900.00 2013 4 2396 Fairway Oaks Dr. Chula Vista, Ca 91915 $579,000.00 2353 4 11 Vista Dr. Chula Vista, Ca 91910 $579,000.00 2040 3 122 Corte Maria Ave. Chula Vista, Ca 91910 $575,000.00 1800 3 287 Eucalyptus court Chula Vista, Ca 91910 $575,000.00 2010 4 1536 Picket Fence Dr. Chula Vista, Ca 91915 $575,000.00 2233 4 1331 Tierra Bonita Pl Chula Vista, Ca 91910 $569,900.00 2446 5 526 Kiley Rd Chula Vista, Ca 91910 $569,900.00 1968 4 1532 Cordelia St. Chula Vista, Ca 91913 $569,900.00 2100 4 Mean $575,760.00 2110 $2,011,800.00 1011190 799449 746700 699060 654390 622480 597439 575760 558560 $827,682.80 Property Address Century 21. Chula Vista Listings Listing Price Square Footage No. Bedrooms 893 Aspen Glen Chula Vista, Ca 9191 $1,199,000.00 4301 7 2822 Lake Crest Ct. Chula Vista, Ca 9195 $1,190,000.00 4278 5 2823 Sutter Ridge Dr. Chula Vista, Ca 91914 $1,125,000.00 4288 6 817 Dorothy Street Chula Vista, Ca 91910 $1,099,000.00 4746 2 1145 Old Janal Ranch Rd. Chula Vista, Ca 9191 $1,089,000.00 4278 6 1036 Mountain Ash Ave. Chula Vista, Ca 91914 $925,000.00 3739 6 2555 Crooked Trail Rd. Chula Vista, Ca 91914 $910,000.00 3617 6 831 Shadow Ridge Pl Chula Vista, Ca 91914 $885,000.00 3657 6 795 Hawks View Chula Vista, Ca 91914 $850,000.00 3498 5 568 Bent Trl Chula Vista, Ca 91914 $839,900.00 3341 6 $1,011,190.00 3974.3 1058 Edgewood Place Chula Vista, Ca 91913 $768,000.00 3151 6 1454 Sugar Pine Pl Chula Vista, Ca 91915 $759,000.00 3200 5 1814 Meeks Bay Chula Vista, Ca 91913 $750,000.00 2950 5 1059 Mountain Ash Chula Vista, Ca 91914 $750,000.00 3739 5 1195 Misty Creek Ct. Chula Vista, Ca 91913 $749,000.00 3682 6 801 Calle Lagasca Chula Vista, Ca 91910 $749,000.00 3136 5 1425 South Creekside Chula Vista, Ca 91915 $749,000.00 3200 4 1470 Old Janal Ranch Rd Chula Vista, Ca 91915 $735,000.00 2944 4 1217 Farmerville St. Chula Vista, Ca 91913 $729,000.00 3694 6 1833 Harrils Mill Ave. Chula Vista, Ca 91913 $729,000.00 3374 5 $746,700.00 3307 1435 Trailwood Ave Chula Vista, Ca 91913 $672,000.00 3157 5 671 Floyd Chula Vista, Ca 91910 $669,000.00 2898 5 952 Isom Chula Vista, Ca 91911 $669,000.00 3334 5 749 N Valley View Dr. Chula Vista, Ca 91914 $655,000.00 2429 4 755 N Fox Run Place Chula Vista, Ca 91914 $650,000.00 3628 6 2145 Plaza Kadie Chula Vista, Ca 91914 $649,900.00 2782 5 1168 Benecia Chula Vista, Ca 91913 $649,000.00 2968 5 1247 Granite Springs Dr. Chula Vista, Ca91915 $649,000.00 2492 5 63 Las Flores Chula Vista, Ca 91910 $642,000.00 2332 4 1737 Bouquet Canyon Rd. Chula Vista, Ca 91913 $639,000.00 2600 4 $654,390.00 2862 2594 Flagstaff Ct. Chula Vista, Ca 91914 $605,000.00 2215 4 652 E J Chula Vista, Ca 91910 $599,990.00 2554 4 2122 Corte Condesa Chula Vista, Ca 91914 $599,900.00 2486 5 1810 Casa Morro St. Chula Vista, Ca 91915 $599,000.00 2225 4 1525 Amador Chula Vista, Ca 91913 $599,000.00 2090 5 678 Felino Way Chula Vista, Ca 91910 $598,000.00 2376 6 2576 Green Valley Rd. Chula Vista, Ca 91915 $595,500.00 2564 4 1737 Picket Fence Chula Vista, Ca 91915 $595,000.00 2491 4 1246 Farmerville St. Chula Vista, Ca 91913 $594,000.00 2623 4 1463 Horn Canyon Ave. Chula Vista, Ca 91915 $589,000.00 2053 5 $597,439.00 2367.7 968 Saint Germain Chula Vista, Ca 91913 $569,000.00 2315 5 1341 Carneros Valley St. Chula Vista, Ca 91913 $569,000.00 2123 4 1433 Oakpoint Ave. Chula Vista, Ca 91913 $560,000.00 2509 4 1431 Blackstone Ave. Chula Vista, Ca 91915 $559,900.00 2014 4 1610 Piedmont Chula Vista, Ca 91913 $559,900.00 1953 4 621 Prairie Chula Vista, Ca 91914 $559,000.00 1730 3 2641 Lightning Trail Ln Chula Vista, Ca 91915 $559,000.00 1856 4 614 Point Caiman Ct. Chula Vista, Ca 91911 $550,000.00 2099 4 1 N 2nd Ave. Chula Vista, Ca 91910 $549,900.00 1431 3 1095 Morgan Hill Dr. Chula Vista, Ca 91913 $549,900.00 2119 4 $558,560.00 2014.9 Real Estate Regression Exercise QNT/351 Version 5 University of Phoenix Material Real Estate Regression Exercise Directions: Use the real estate data you used for your Week 2 learning team assignment. Analyze the data and explain your answers. You are consulting for a large real estate firm. You have been asked to construct a model that can predict listing prices based on square footages for homes in the city you've been researching. You have data on square footages and listing prices for 100 homes. 1. Which variable is the independent variable (x) and which is the dependent variable (y)? 2. Click on any cell. Click on InsertScatterScatter with markers (upper left). To add a trendline, click ToolsLayoutTrendlineLinear Trendline Does the scatterplot indicate observable correlation? If so, does it seem to be strong or weak? In what direction? 3. Click on DataData AnalysisRegressionOK. Highlight your data (including your two headings) and input the correct columns into Input Y Range and Input X Range, respectively. Make sure to check the box entitled \"Labels\". (a) What is the Coefficient of Correlation between square footage and listing price? (b) Does your Coefficient of Correlation seem consistent with your answer to #2 above? Why or why not? (c) What proportion of the variation in listing price is determined by variation in the square footage? What proportion of the variation in listing price is due to other factors? (d) Check the coefficients in your summary output. What is the regression equation relating square footage to listing price? Copyright 2016 by University of Phoenix. All rights reserved. 1 Real Estate Regression Exercise QNT/351 Version 5 (e) Test the significance of the slope. What is your t-value for the slope? Do you conclude that there is no significant relationship between the two variables or do you conclude that there is a significant relationship between the variables? (f) Using the regression equation that you designated in #3(d) above, what is the predicted sales price for a house of 2100 square feet? Copyright 2016 by University of Phoenix. All rights reserved. 2