File Home Insert Page Layout Formulas Data Review View Help Acrobat Search .110 . A^ Av | | 9- wrap Text MS Sans Serif General Conditional Format as Cell Insert Delete Format ort &Find & Filter Select Format Painter Formatting Table Styles Editing Cells DR 0 Houses Sold by Region 2(Components may not add to total because of rounding Number of housing units in thousands.) 1 Year 1963 1964 1965 1966 1967 1968 1969 15e 1971 01972 1973 U.S NE MW SW 199 141 56590 146 200 129 57594142 210 129 SHOW DESCRIPTIVE STATISTICS (Using Tools> Data Analysis) UNITED STATES ONLY SHOW DESCRIPTIVE STATISTICS Using Functions (Include Quartiles and IQR) UNITED STATES ONLY 84 48777112 113 166 179 119 CREATE A BAR GRAPH FROM 2008- 2018 WITH TITLES 490 73 119177 121 48 6297 175 114 485 61 100 203 121 656 82 127 270 176 MAIN TITLE AXIS TITLES) UNITED STATES ONLY CREATE A TREND GRAPH FOR ALL YEARS AND ADD THE TREND LINE WITH EQUATION THAT HAS THE HIGHEST RSQUARED. SHOW THE RSQUARED COMPARISONS IN A TABLE BELOW THE GRAPH UNITED STATES ONL 71896 130 305 187 634 95120 257 161 519 69103 207 139 54971106 222 150 64672 128 247 199 81986162 317 255 817 78 145 33 262 0967112 304 225 5455081 267 145 4364660 219 112 412 4748 21999 623 7671 323 152 639 9476 309 160 688 11282 323 171 750 136 96 322 196 671 11797271186 676 10197 276 202 650 86102 260 202 89 225 149 14 1:6 12 197 1975 4 1976 Logarithmic 16 1978 7 1979 18 1980 9 1981 20 1982 21 1983 1984 23 1985 24 1986 25 1987 28 1988 27 1989 28 1990 115 Polynomial Order 2 CONDUCTA T-TEST COMPARING ANY REGIONS. MAKE SURE PARIN ATI KNOW WHICH TWO REGION 25 27 HYPOTHESIS TESTING-USING THE US ONLY DATA FROM 2008 to 2018 S,UNITS SOLD WOULD NOMI 475. CONDUCTA DICTED THAT DURING THOS E PERIO RMINE IF THAT PREDICTION IS ACCEPTABLE Data Type here to search 149 225 89 215 0 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 STATE THE NULL AND AL TERNATIVE HYPOTHESIS 144 57 SUMMARY OUTPUT 116 259 123 295 123 125 137 140 164 168 610 188 191 187 670 667 757 35 36 37 HYPOTHESIS TEST AND CONCLUSION 337 223 243 242 35 886 16 880 877 968 66 15 962 973 1086 1203 1283 1051 776 0.05 244 A3923 406 439 450 6618 511348 239 164 2001 INTERPRET THE RESULTS 307 10 562 ANOVA COMPARE EACH OF THE 4 REGIONS. CONDUCT AN ANOVA USING THE DATA ANALYSIS TOOL (SINGLE FACTOR PLACE THE RESULTS BELOW THE TABLE AND INTERPRET THE RESULTS using the F and Fcrit THE HYPOTHESIS IS THAT MEAN HOUSES SOLD ARE THE SAME 638 267 181 161 118 47 411 2007 35 87 375 TIP: if F> F crit, we reject the null hypothesis 173 168 195 2010 2011 2012 2013 2014 2015 2016 2017 2018 Anova: Single Factor NTERPRET THE RESULTS 97 233 105 108 130 142 163 161 29 429 437 243 318 561 613 619 57 Data File Home Insert Page Layout Formulas Data Review View Help Acrobat Search .110 . A^ Av | | 9- wrap Text MS Sans Serif General Conditional Format as Cell Insert Delete Format ort &Find & Filter Select Format Painter Formatting Table Styles Editing Cells DR 0 Houses Sold by Region 2(Components may not add to total because of rounding Number of housing units in thousands.) 1 Year 1963 1964 1965 1966 1967 1968 1969 15e 1971 01972 1973 U.S NE MW SW 199 141 56590 146 200 129 57594142 210 129 SHOW DESCRIPTIVE STATISTICS (Using Tools> Data Analysis) UNITED STATES ONLY SHOW DESCRIPTIVE STATISTICS Using Functions (Include Quartiles and IQR) UNITED STATES ONLY 84 48777112 113 166 179 119 CREATE A BAR GRAPH FROM 2008- 2018 WITH TITLES 490 73 119177 121 48 6297 175 114 485 61 100 203 121 656 82 127 270 176 MAIN TITLE AXIS TITLES) UNITED STATES ONLY CREATE A TREND GRAPH FOR ALL YEARS AND ADD THE TREND LINE WITH EQUATION THAT HAS THE HIGHEST RSQUARED. SHOW THE RSQUARED COMPARISONS IN A TABLE BELOW THE GRAPH UNITED STATES ONL 71896 130 305 187 634 95120 257 161 519 69103 207 139 54971106 222 150 64672 128 247 199 81986162 317 255 817 78 145 33 262 0967112 304 225 5455081 267 145 4364660 219 112 412 4748 21999 623 7671 323 152 639 9476 309 160 688 11282 323 171 750 136 96 322 196 671 11797271186 676 10197 276 202 650 86102 260 202 89 225 149 14 1:6 12 197 1975 4 1976 Logarithmic 16 1978 7 1979 18 1980 9 1981 20 1982 21 1983 1984 23 1985 24 1986 25 1987 28 1988 27 1989 28 1990 115 Polynomial Order 2 CONDUCTA T-TEST COMPARING ANY REGIONS. MAKE SURE PARIN ATI KNOW WHICH TWO REGION 25 27 HYPOTHESIS TESTING-USING THE US ONLY DATA FROM 2008 to 2018 S,UNITS SOLD WOULD NOMI 475. CONDUCTA DICTED THAT DURING THOS E PERIO RMINE IF THAT PREDICTION IS ACCEPTABLE Data Type here to search 149 225 89 215 0 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 STATE THE NULL AND AL TERNATIVE HYPOTHESIS 144 57 SUMMARY OUTPUT 116 259 123 295 123 125 137 140 164 168 610 188 191 187 670 667 757 35 36 37 HYPOTHESIS TEST AND CONCLUSION 337 223 243 242 35 886 16 880 877 968 66 15 962 973 1086 1203 1283 1051 776 0.05 244 A3923 406 439 450 6618 511348 239 164 2001 INTERPRET THE RESULTS 307 10 562 ANOVA COMPARE EACH OF THE 4 REGIONS. CONDUCT AN ANOVA USING THE DATA ANALYSIS TOOL (SINGLE FACTOR PLACE THE RESULTS BELOW THE TABLE AND INTERPRET THE RESULTS using the F and Fcrit THE HYPOTHESIS IS THAT MEAN HOUSES SOLD ARE THE SAME 638 267 181 161 118 47 411 2007 35 87 375 TIP: if F> F crit, we reject the null hypothesis 173 168 195 2010 2011 2012 2013 2014 2015 2016 2017 2018 Anova: Single Factor NTERPRET THE RESULTS 97 233 105 108 130 142 163 161 29 429 437 243 318 561 613 619 57 Data
