Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i couldnt attach the excel file here but if you want i can send it to you File Home Insert Page Layout Formulas Data Review
i couldnt attach the excel file here but if you want i can send it to you
File Home Insert Page Layout Formulas Data Review View Help Acrobat Searclh AutoSum A |10 A" Ay | 9- Wrap Text MS Sans Serif Paste L Copy Delete Format Conditional Format as Cell Formatting-Table Styles nsert Sort & Find arFilter-Select Format Painter Clipboard Cells Editing Houses Sold by Region 2Components may not add to total because of rounding. Number of housing units in thousands.) Year U.S NE MW 13 141 964 1965 1966 1967 1968 1969 1970 1971 0 1972 56590 146 200 129 UNITED STATES ONLY SHOW DESCRIPTIVE STATISTICS Using Functions (Include Quartiles and IQR) UNITED STATES ONLY 575 94142 0 129 113 166 99 84 12 179 119 490 73 119 177 121 487 1 MAIN TITLE, AXIS TITLES) UNITED STATES ONLY 448 62 97 5 114 485 61 100 203 121 656 82 27 270176 718 96 130 305 187 634 95 120 257 161 519 69 103 207 139 106 222 150 128 247 199 819 8 162 317 255 81778 145 331 262 112 304 225 REATE 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 ONLY 12 13 14 11 1973 Trend Linear 2 1974 1975 1976 1977 6 1978 1979 1980 19 1981 1982 1983 1984 23 1985 1983 1987 1988 27 1989 15 lic Polynomial Order 2 4364660 219 112 23 412 4748 219 99 623 7671 323152 639 94 76 309 160 688 11282323 171 322 196 271 186 676 101 97 276 202 650 86 102 260 202 CONDUCTA T-TEST COMPARING ANY TWO REGIONS. MAKE SURE SO THATIKNOW WHICH TWO REGIONS YOU ARE COMPARING INCLUDE THE 21 25 750 671 136 F. HYPOTHESIS TESTING-USING THE US ONLY DATA FROM 2008 to 2018 ECONOMISTS PREDICTED THAT DURING THOSE PERIODS, UNITS SOLD WOULD BE 475. CONDUCT A HYPOTHESIS TEST TO DETERMINE F THAT PREDICTION S ACCEPTABLE 29 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 Searclh AutoSum A |10 A" Ay | 9- Wrap Text MS Sans Serif Paste L Copy Delete Format Conditional Format as Cell Formatting-Table Styles nsert Sort & Find arFilter-Select Format Painter Clipboard Cells Editing Houses Sold by Region 2Components may not add to total because of rounding. Number of housing units in thousands.) Year U.S NE MW 13 141 964 1965 1966 1967 1968 1969 1970 1971 0 1972 56590 146 200 129 UNITED STATES ONLY SHOW DESCRIPTIVE STATISTICS Using Functions (Include Quartiles and IQR) UNITED STATES ONLY 575 94142 0 129 113 166 99 84 12 179 119 490 73 119 177 121 487 1 MAIN TITLE, AXIS TITLES) UNITED STATES ONLY 448 62 97 5 114 485 61 100 203 121 656 82 27 270176 718 96 130 305 187 634 95 120 257 161 519 69 103 207 139 106 222 150 128 247 199 819 8 162 317 255 81778 145 331 262 112 304 225 REATE 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 ONLY 12 13 14 11 1973 Trend Linear 2 1974 1975 1976 1977 6 1978 1979 1980 19 1981 1982 1983 1984 23 1985 1983 1987 1988 27 1989 15 lic Polynomial Order 2 4364660 219 112 23 412 4748 219 99 623 7671 323152 639 94 76 309 160 688 11282323 171 322 196 271 186 676 101 97 276 202 650 86 102 260 202 CONDUCTA T-TEST COMPARING ANY TWO REGIONS. MAKE SURE SO THATIKNOW WHICH TWO REGIONS YOU ARE COMPARING INCLUDE THE 21 25 750 671 136 F. HYPOTHESIS TESTING-USING THE US ONLY DATA FROM 2008 to 2018 ECONOMISTS PREDICTED THAT DURING THOSE PERIODS, UNITS SOLD WOULD BE 475. CONDUCT A HYPOTHESIS TEST TO DETERMINE F THAT PREDICTION S ACCEPTABLE 29 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 DataStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started