Edit the Answer (Quantitative Business Analysis, Quality Work Only)

profilegwcthe
assignt5.xlsx
Home>Mathematics homework help>Edit the Answer (Quantitative Business Analysis, Quality Work Only)

Descriptive Statistics

Western Region Eastern Region Western Region
Original Price Sale Price Days to Sell Original Price Sale Price Days to Sell Original Price Sale Price Days to Sell
82 60 20 148 139 33 Minimum 54 34 1
140 123 26 103 89 59 1st Quartile 81.25 58.5 23
80 70 16 112 100 189 Median 113.5 79 58.5
89 50 72 81 61 145 3rd Quartile 136 100 100
135 120 18 136 100 91 Maximum 150 143 189
146 143 109 112 89 66 Mean 109.78 80.44 62.68
80 80 79 121 100 81 Standard Deviation 27.919 26.960 44.784
125 100 130 83 60 65 Range 96 109 188
70 60 100 99 80 100 Mode No Mode No Mode 25
81 52 96 93 65 15
103 95 14 98 70 34 Eastern Region
118 100 33 106 100 102 Original Price Sale Price Days to Sell
136 100 101 109 99 45 Minimum 73 40 2
101 50 55 102 89 166 1st Quartile 94.25 65.75 34
140 75 69 96 96 50 Median 103 86 56
73 42 120 103 40 56 3rd Quartile 124 100 80.25
135 99 90 84 60 102 Maximum 149 141 189
89 45 13 96 50 71 Mean 108.62 85.24 62.36
134 65 30 125 75 45 Standard Deviation 20.905 23.716 40.553
109 45 23 146 120 10 Range 76 101 187
145 100 106 103 103 3 Mode 103 No Mode No Mode
150 100 133 82 60 25
136 70 62 149 100 23
120 88 74 92 88 45
137 137 101 111 100 77
132 50 96 148 70 100
75 42 98 98 68 65
71 62 189 102 82 34
109 89 122 109 100 19
130 119 108 137 137 2
108 89 19 85 65 34
146 100 125 94 84 45
98 80 15 141 141 100
82 50 7 131 120 8
79 79 1 130 120 10
138 99 17 107 80 45
95 79 23 113 80 120
136 129 30 142 100 100
74 34 17 105 60 36
139 100 25 140 70 75
143 89 120 83 43 69
120 109 35 97 90 45
75 75 25 95 90 38
136 69 15 129 99 56
124 100 75 93 60 71
132 69 25 118 100 34
91 79 33 89 80 55
80 50 49 73 60 67
54 54 100 79 60 78
68 58 75 103 70 114

Outliers-I

Western Region
Original Price High Performance Outlier Low Performance Outlier Sale Price High Performance Outlier Low Performance Outlier Days to Sell High Performance Outlier Low Performance Outlier
82 Not Outlier Not Outlier 60 Not Outlier Not Outlier 20 Not Outlier Not Outlier
140 Not Outlier Not Outlier 123 Not Outlier Not Outlier 26 Not Outlier Not Outlier
80 Not Outlier Not Outlier 70 Not Outlier Not Outlier 16 Not Outlier Not Outlier
89 Not Outlier Not Outlier 50 Not Outlier Not Outlier 72 Not Outlier Not Outlier
135 Not Outlier Not Outlier 120 Not Outlier Not Outlier 18 Not Outlier Not Outlier
146 Not Outlier Not Outlier 143 Not Outlier Not Outlier 109 Not Outlier Not Outlier
80 Not Outlier Not Outlier 80 Not Outlier Not Outlier 79 Not Outlier Not Outlier
125 Not Outlier Not Outlier 100 Not Outlier Not Outlier 130 Not Outlier Not Outlier
70 Not Outlier Not Outlier 60 Not Outlier Not Outlier 100 Not Outlier Not Outlier
81 Not Outlier Not Outlier 52 Not Outlier Not Outlier 96 Not Outlier Not Outlier
103 Not Outlier Not Outlier 95 Not Outlier Not Outlier 14 Not Outlier Not Outlier
118 Not Outlier Not Outlier 100 Not Outlier Not Outlier 33 Not Outlier Not Outlier
136 Not Outlier Not Outlier 100 Not Outlier Not Outlier 101 Not Outlier Not Outlier
101 Not Outlier Not Outlier 50 Not Outlier Not Outlier 55 Not Outlier Not Outlier
140 Not Outlier Not Outlier 75 Not Outlier Not Outlier 69 Not Outlier Not Outlier
73 Not Outlier Not Outlier 42 Not Outlier Not Outlier 120 Not Outlier Not Outlier
135 Not Outlier Not Outlier 99 Not Outlier Not Outlier 90 Not Outlier Not Outlier
89 Not Outlier Not Outlier 45 Not Outlier Not Outlier 13 Not Outlier Not Outlier
134 Not Outlier Not Outlier 65 Not Outlier Not Outlier 30 Not Outlier Not Outlier
109 Not Outlier Not Outlier 45 Not Outlier Not Outlier 23 Not Outlier Not Outlier
145 Not Outlier Not Outlier 100 Not Outlier Not Outlier 106 Not Outlier Not Outlier
150 Not Outlier Not Outlier 100 Not Outlier Not Outlier 133 Not Outlier Not Outlier
136 Not Outlier Not Outlier 70 Not Outlier Not Outlier 62 Not Outlier Not Outlier
120 Not Outlier Not Outlier 88 Not Outlier Not Outlier 74 Not Outlier Not Outlier
137 Not Outlier Not Outlier 137 Not Outlier Not Outlier 101 Not Outlier Not Outlier
132 Not Outlier Not Outlier 50 Not Outlier Not Outlier 96 Not Outlier Not Outlier
75 Not Outlier Not Outlier 42 Not Outlier Not Outlier 98 Not Outlier Not Outlier
71 Not Outlier Not Outlier 62 Not Outlier Not Outlier 189 Not Outlier Not Outlier
109 Not Outlier Not Outlier 89 Not Outlier Not Outlier 122 Not Outlier Not Outlier
130 Not Outlier Not Outlier 119 Not Outlier Not Outlier 108 Not Outlier Not Outlier
108 Not Outlier Not Outlier 89 Not Outlier Not Outlier 19 Not Outlier Not Outlier
146 Not Outlier Not Outlier 100 Not Outlier Not Outlier 125 Not Outlier Not Outlier
98 Not Outlier Not Outlier 80 Not Outlier Not Outlier 15 Not Outlier Not Outlier
82 Not Outlier Not Outlier 50 Not Outlier Not Outlier 7 Not Outlier Not Outlier
79 Not Outlier Not Outlier 79 Not Outlier Not Outlier 1 Not Outlier Not Outlier
138 Not Outlier Not Outlier 99 Not Outlier Not Outlier 17 Not Outlier Not Outlier
95 Not Outlier Not Outlier 79 Not Outlier Not Outlier 23 Not Outlier Not Outlier
136 Not Outlier Not Outlier 129 Not Outlier Not Outlier 30 Not Outlier Not Outlier
74 Not Outlier Not Outlier 34 Not Outlier Not Outlier 17 Not Outlier Not Outlier
139 Not Outlier Not Outlier 100 Not Outlier Not Outlier 25 Not Outlier Not Outlier
143 Not Outlier Not Outlier 89 Not Outlier Not Outlier 120 Not Outlier Not Outlier
120 Not Outlier Not Outlier 109 Not Outlier Not Outlier 35 Not Outlier Not Outlier
75 Not Outlier Not Outlier 75 Not Outlier Not Outlier 25 Not Outlier Not Outlier
136 Not Outlier Not Outlier 69 Not Outlier Not Outlier 15 Not Outlier Not Outlier
124 Not Outlier Not Outlier 100 Not Outlier Not Outlier 75 Not Outlier Not Outlier
132 Not Outlier Not Outlier 69 Not Outlier Not Outlier 25 Not Outlier Not Outlier
91 Not Outlier Not Outlier 79 Not Outlier Not Outlier 33 Not Outlier Not Outlier
80 Not Outlier Not Outlier 50 Not Outlier Not Outlier 49 Not Outlier Not Outlier
54 Not Outlier Not Outlier 54 Not Outlier Not Outlier 100 Not Outlier Not Outlier
68 Not Outlier Not Outlier 58 Not Outlier Not Outlier 75 Not Outlier Not Outlier

Outliers-II

Eastern Region
Original Price High Performance Outlier Low Performance Outlier Sale Price High Performance Outlier Low Performance Outlier Days to Sell High Performance Outlier Low Performance Outlier
148 Not Outlier Not Outlier 139 Not Outlier Not Outlier 33 Not Outlier Not Outlier
103 Not Outlier Not Outlier 89 Not Outlier Not Outlier 59 Not Outlier Not Outlier
112 Not Outlier Not Outlier 100 Not Outlier Not Outlier 189 Outlier Not Outlier
81 Not Outlier Not Outlier 61 Not Outlier Not Outlier 145 Not Outlier Not Outlier
136 Not Outlier Not Outlier 100 Not Outlier Not Outlier 91 Not Outlier Not Outlier
112 Not Outlier Not Outlier 89 Not Outlier Not Outlier 66 Not Outlier Not Outlier
121 Not Outlier Not Outlier 100 Not Outlier Not Outlier 81 Not Outlier Not Outlier
83 Not Outlier Not Outlier 60 Not Outlier Not Outlier 65 Not Outlier Not Outlier
99 Not Outlier Not Outlier 80 Not Outlier Not Outlier 100 Not Outlier Not Outlier
93 Not Outlier Not Outlier 65 Not Outlier Not Outlier 15 Not Outlier Not Outlier
98 Not Outlier Not Outlier 70 Not Outlier Not Outlier 34 Not Outlier Not Outlier
106 Not Outlier Not Outlier 100 Not Outlier Not Outlier 102 Not Outlier Not Outlier
109 Not Outlier Not Outlier 99 Not Outlier Not Outlier 45 Not Outlier Not Outlier
102 Not Outlier Not Outlier 89 Not Outlier Not Outlier 166 Not Outlier Not Outlier
96 Not Outlier Not Outlier 96 Not Outlier Not Outlier 50 Not Outlier Not Outlier
103 Not Outlier Not Outlier 40 Not Outlier Not Outlier 56 Not Outlier Not Outlier
84 Not Outlier Not Outlier 60 Not Outlier Not Outlier 102 Not Outlier Not Outlier
96 Not Outlier Not Outlier 50 Not Outlier Not Outlier 71 Not Outlier Not Outlier
125 Not Outlier Not Outlier 75 Not Outlier Not Outlier 45 Not Outlier Not Outlier
146 Not Outlier Not Outlier 120 Not Outlier Not Outlier 10 Not Outlier Not Outlier
103 Not Outlier Not Outlier 103 Not Outlier Not Outlier 3 Not Outlier Not Outlier
82 Not Outlier Not Outlier 60 Not Outlier Not Outlier 25 Not Outlier Not Outlier
149 Not Outlier Not Outlier 100 Not Outlier Not Outlier 23 Not Outlier Not Outlier
92 Not Outlier Not Outlier 88 Not Outlier Not Outlier 45 Not Outlier Not Outlier
111 Not Outlier Not Outlier 100 Not Outlier Not Outlier 77 Not Outlier Not Outlier
148 Not Outlier Not Outlier 70 Not Outlier Not Outlier 100 Not Outlier Not Outlier
98 Not Outlier Not Outlier 68 Not Outlier Not Outlier 65 Not Outlier Not Outlier
102 Not Outlier Not Outlier 82 Not Outlier Not Outlier 34 Not Outlier Not Outlier
109 Not Outlier Not Outlier 100 Not Outlier Not Outlier 19 Not Outlier Not Outlier
137 Not Outlier Not Outlier 137 Not Outlier Not Outlier 2 Not Outlier Not Outlier
85 Not Outlier Not Outlier 65 Not Outlier Not Outlier 34 Not Outlier Not Outlier
94 Not Outlier Not Outlier 84 Not Outlier Not Outlier 45 Not Outlier Not Outlier
141 Not Outlier Not Outlier 141 Not Outlier Not Outlier 100 Not Outlier Not Outlier
131 Not Outlier Not Outlier 120 Not Outlier Not Outlier 8 Not Outlier Not Outlier
130 Not Outlier Not Outlier 120 Not Outlier Not Outlier 10 Not Outlier Not Outlier
107 Not Outlier Not Outlier 80 Not Outlier Not Outlier 45 Not Outlier Not Outlier
113 Not Outlier Not Outlier 80 Not Outlier Not Outlier 120 Not Outlier Not Outlier
142 Not Outlier Not Outlier 100 Not Outlier Not Outlier 100 Not Outlier Not Outlier
105 Not Outlier Not Outlier 60 Not Outlier Not Outlier 36 Not Outlier Not Outlier
140 Not Outlier Not Outlier 70 Not Outlier Not Outlier 75 Not Outlier Not Outlier
83 Not Outlier Not Outlier 43 Not Outlier Not Outlier 69 Not Outlier Not Outlier
97 Not Outlier Not Outlier 90 Not Outlier Not Outlier 45 Not Outlier Not Outlier
95 Not Outlier Not Outlier 90 Not Outlier Not Outlier 38 Not Outlier Not Outlier
129 Not Outlier Not Outlier 99 Not Outlier Not Outlier 56 Not Outlier Not Outlier
93 Not Outlier Not Outlier 60 Not Outlier Not Outlier 71 Not Outlier Not Outlier
118 Not Outlier Not Outlier 100 Not Outlier Not Outlier 34 Not Outlier Not Outlier
89 Not Outlier Not Outlier 80 Not Outlier Not Outlier 55 Not Outlier Not Outlier
73 Not Outlier Not Outlier 60 Not Outlier Not Outlier 67 Not Outlier Not Outlier
79 Not Outlier Not Outlier 60 Not Outlier Not Outlier 78 Not Outlier Not Outlier
103 Not Outlier Not Outlier 70 Not Outlier Not Outlier 114 Not Outlier Not Outlier

Sheet1

Western Region
Original Price Sale Price SUMMARY OUTPUT
82 60
140 123 Regression Statistics
80 70 Multiple R 0.6885527078
89 50 R Square 0.4741048315
135 120 Adjusted R Square 0.4631486821
146 143 Standard Error 19.7539292555
80 80 Observations 50
125 100
70 60 ANOVA
81 52 df SS MS F Significance F
103 95 Regression 1 16885.8693905156 16885.8693905156 43.2729434888 0.0000000326
118 100 Residual 48 18730.4506094844 390.2177210309
136 100 Total 49 35616.32
101 50
140 75 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
73 42 Intercept 7.4465198989 11.4425041859 0.6507771182 0.5182936268 -15.5601767315 30.4532165293 -15.5601767315 30.4532165293
135 99 Original Price 0.6649069056 0.1010770655 6.5782173489 0.0000000326 0.4616778446 0.8681359667 0.4616778446 0.8681359667
89 45
134 65 87.2353485756
109 45
145 100
150 100
136 70
120 88
137 137
132 50
75 42
71 62
109 89
130 119
108 89
146 100
98 80
82 50
79 79
138 99
95 79
136 129
74 34
139 100
143 89
120 109
75 75
136 69
124 100
132 69
91 79
80 50
54 54
68 58

Sheet2

Western Region
Original Price Days to Sell SUMMARY OUTPUT
82 20
140 26 Regression Statistics
80 16 Multiple R 0.0947244173
89 72 R Square 0.0089727152
135 18 Adjusted R Square -0.0116736865
146 109 Standard Error 45.0451323539
80 79 Observations 50
125 130
70 100 ANOVA
81 96 df SS MS F Significance F
103 14 Regression 1 881.8104587195 881.8104587195 0.4345897818 0.5128958057
118 33 Residual 48 97395.0695412804 2029.0639487767
136 101 Total 49 98276.88
101 55
140 69 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
73 120 Intercept 45.9994648455 26.092485644 1.7629391647 0.0842764553 -6.4629937032 98.4619233942 -6.4629937032 98.4619233942
135 90 Original Price 0.1519451189 0.2304872987 0.6592342389 0.5128958057 -0.311480655 0.6153708928 -0.311480655 0.6153708928
89 13
134 30 64.2328791153
109 23
145 106
150 133
136 62
120 74
137 101
132 96
75 98
71 189
109 122
130 108
108 19
146 125
98 15
82 7
79 1
138 17
95 23
136 30
74 17
139 25
143 120
120 35
75 25
136 15
124 75
132 25
91 33
80 49
54 100
68 75

Sheet3

Eastern Region
Original Price Sale Price SUMMARY OUTPUT
148 139
103 89 Regression Statistics
112 100 Multiple R 0.6836548207
81 61 R Square 0.4673839138
136 100 Adjusted R Square 0.4562877454
112 89 Standard Error 17.4877908987
121 100 Observations 50
83 60
99 80 ANOVA
93 65 df SS MS F Significance F
98 70 Regression 1 12881.6241351877 12881.6241351877 42.1211984515 0.0000000445
106 100 Residual 48 14679.4958648123 305.8228305169
109 99 Total 49 27561.12
102 89
96 96 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
103 40 Intercept 0.9941645053 13.2141971025 0.0752345752 0.9403407642 -25.5747594831 27.5630884937 -25.5747594831 27.5630884937
84 60 Original Price 0.7756015052 0.1195056074 6.4900846259 0.0000000445 0.5353193773 1.0158836331 0.5353193773 1.0158836331
96 50
125 75 97.9443526552
146 120
103 103
82 60
149 100
92 88
111 100
148 70
98 68
102 82
109 100
137 137
85 65
94 84
141 141
131 120
130 120
107 80
113 80
142 100
105 60
140 70
83 43
97 90
95 90
129 99
93 60
118 100
89 80
73 60
79 60
103 70

Sheet4

Eastern Region
Original Price Days to Sell SUMMARY OUTPUT
148 33
103 59 Regression Statistics
112 189 Multiple R 0.1063102194
81 145 R Square 0.0113018627
136 91 Adjusted R Square -0.0092960151
112 66 Standard Error 40.7412506244
121 81 Observations 50
83 65
99 100 ANOVA
93 15 df SS MS F Significance F
98 34 Regression 1 910.7438829389 910.7438829389 0.5486906383 0.4624615491
106 102 Residual 48 79672.7761170611 1659.8495024388
109 45 Total 49 80583.52
102 166
96 50 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
103 56 Intercept 84.7606830742 30.7850728015 2.7533046168 0.0083052921 22.8631456835 146.6582204648 22.8631456835 146.6582204648
84 102 Original Price -0.2062298202 0.278411832 -0.7407365512 0.4624615491 -0.7660143266 0.3535546861 -0.7660143266 0.3535546861
96 71
125 45 58.9819555445
146 10
103 3
82 25
149 23
92 45
111 77
148 100
98 65
102 34
109 19
137 2
85 34
94 45
141 100
131 8
130 10
107 45
113 120
142 100
105 36
140 75
83 69
97 45
95 38
129 56
93 71
118 34
89 55
73 67
79 78
103 114

1

2

3

4

5

6

7

8

9

A

B

C

D

Original Price

Sale Price

Days to Sell

82

60

20

140

123

26

80

70

16

89

50

72

135

120

18

146

143

109

Western Region