Business Project

profilelbrdy0
inferential_statistics_and_findings_spreadsheet.xlsx
Home>Mathematics homework help>Business Project

Sheet1

Raw Data
Sample # Total Overhead Cost per Packet of 30 Seeds Sales Price per Packet of 30 Seeds Sample # Total Overhead Cost per Packet of 30 Seeds Sales Price per Packet of 30 Seeds Sample # Total Overhead Cost per Packet of 30 Seeds Sales Price per Packet of 30 Seeds Sample # Total Overhead Cost per Packet of 30 Seeds Sales Price per Packet of 30 Seeds Sample # Total Overhead Cost per Packet of 30 Seeds Sales Price per Packet of 30 Seeds
1 $2.63 $3.95 78 $2.50 $2.90 155 $1.63 $3.51 232 $2.69 $3.16 309 $2.20 $3.99
2 $2.71 $4.15 79 $1.85 $3.12 156 $2.25 $3.28 233 $2.42 $3.75 310 $1.39 $3.91
3 $2.15 $3.13 80 $2.17 $3.74 157 $2.33 $3.96 234 $1.41 $4.03 311 $1.43 $3.87
4 $2.46 $3.83 81 $1.88 $3.55 158 $1.91 $2.97 235 $2.30 $3.00 312 $2.57 $3.76
5 $1.90 $3.86 82 $2.47 $3.91 159 $1.53 $3.39 236 $2.51 $4.14 313 $1.88 $2.98
6 $1.73 $4.31 83 $2.04 $4.22 160 $1.61 $3.76 237 $2.32 $3.14 314 $1.52 $3.52
7 $1.49 $3.17 84 $2.85 $3.05 161 $2.02 $2.93 238 $1.98 $3.80 315 $1.74 $2.99
8 $2.30 $3.22 85 $1.84 $3.43 162 $1.83 $3.45 239 $2.45 $3.55 316 $1.74 $4.35
9 $2.40 $3.05 86 $2.04 $2.97 163 $2.62 $2.98 240 $1.54 $4.02 317 $1.49 $3.52
10 $1.56 $3.06 87 $2.20 $3.57 164 $2.07 $4.01 241 $2.15 $2.97 318 $2.75 $3.85
11 $2.31 $3.11 88 $1.57 $4.26 165 $1.78 $3.78 242 $2.62 $2.91 319 $2.85 $4.03
12 $1.47 $3.88 89 $2.00 $4.27 166 $1.75 $3.79 243 $2.60 $4.34 320 $1.61 $4.00
13 $1.45 $3.58 90 $1.81 $3.44 167 $2.23 $2.88 244 $2.31 $3.72 321 $2.30 $3.47
14 $2.04 $2.99 91 $2.63 $3.57 168 $2.03 $3.34 245 $1.49 $3.23 322 $1.58 $3.94
15 $2.26 $2.94 92 $1.95 $3.85 169 $2.67 $3.85 246 $2.52 $4.21 323 $2.68 $2.86
16 $1.51 $4.16 93 $2.83 $4.20 170 $1.64 $4.07 247 $2.25 $3.50 324 $2.13 $3.62
17 $2.64 $2.99 94 $2.51 $4.32 171 $2.64 $4.00 248 $1.76 $3.08 325 $2.68 $3.55
18 $2.59 $3.31 95 $1.66 $4.02 172 $2.70 $3.53 249 $1.76 $3.22 326 $2.31 $3.48
19 $2.48 $2.93 96 $1.99 $3.22 173 $2.50 $3.48 250 $2.66 $3.45 327 $2.68 $3.34
20 $2.49 $4.31 97 $2.42 $4.26 174 $2.11 $3.08 251 $2.54 $3.00 328 $2.69 $4.32
21 $2.26 $4.19 98 $1.41 $3.36 175 $1.53 $2.99 252 $1.90 $4.31 329 $1.96 $3.29
22 $1.61 $2.88 99 $1.56 $3.74 176 $2.52 $3.00 253 $2.68 $3.63 330 $1.51 $2.96
23 $2.17 $3.53 100 $2.68 $4.24 177 $1.97 $4.30 254 $1.86 $4.02 331 $2.69 $4.01
24 $2.49 $3.97 101 $1.36 $3.76 178 $2.83 $3.88 255 $2.29 $3.37 332 $1.61 $4.33
25 $1.60 $3.85 102 $2.76 $3.60 179 $2.02 $3.12 256 $2.07 $4.04 333 $1.41 $3.78
26 $2.20 $4.05 103 $2.72 $3.50 180 $1.60 $4.34 257 $1.49 $3.96 334 $2.20 $4.21
27 $1.44 $3.23 104 $1.61 $4.08 181 $2.06 $4.09 258 $2.65 $2.87 335 $2.51 $3.24
28 $2.25 $4.10 105 $2.66 $4.19 182 $2.52 $3.16 259 $2.37 $3.62 336 $1.98 $3.20
29 $2.29 $2.87 106 $1.94 $3.97 183 $1.67 $3.58 260 $2.67 $3.72 337 $1.67 $3.23
30 $2.44 $4.21 107 $2.18 $2.98 184 $2.42 $3.78 261 $1.35 $2.99 338 $2.40 $2.89
31 $2.21 $4.10 108 $2.52 $3.31 185 $1.49 $4.28 262 $1.99 $3.40 339 $2.19 $3.10
32 $2.07 $3.28 109 $1.64 $3.65 186 $1.41 $4.31 263 $1.61 $4.06 340 $1.97 $3.02
33 $2.51 $3.13 110 $2.39 $4.26 187 $1.37 $3.95 264 $1.80 $3.82 341 $2.33 $3.51
34 $2.24 $3.59 111 $2.84 $3.51 188 $1.63 $3.61 265 $2.40 $3.52 342 $2.14 $3.48
35 $2.34 $3.69 112 $1.41 $3.40 189 $1.98 $3.33 266 $1.84 $3.86 343 $2.44 $3.00
36 $1.49 $3.33 113 $2.71 $3.30 190 $1.82 $3.07 267 $2.14 $2.99 344 $1.80 $3.82
37 $2.57 $3.39 114 $2.78 $3.94 191 $1.62 $3.41 268 $2.64 $3.15 345 $1.41 $2.99
38 $2.16 $3.28 115 $1.88 $3.49 192 $1.84 $3.88 269 $2.46 $3.43 346 $2.47 $3.15
39 $2.76 $4.32 116 $1.43 $3.51 193 $1.38 $3.55 270 $2.15 $4.35 347 $2.13 $4.28
40 $1.81 $3.56 117 $2.20 $3.47 194 $2.82 $3.99 271 $2.53 $3.46 348 $1.71 $2.89
41 $2.48 $4.21 118 $1.66 $3.45 195 $2.00 $4.16 272 $1.56 $3.64 349 $2.18 $3.79
42 $1.72 $2.95 119 $2.49 $3.64 196 $1.60 $3.83 273 $1.36 $4.29 350 $2.49 $3.20
43 $2.08 $3.38 120 $2.75 $4.22 197 $2.05 $3.66 274 $2.55 $3.75 351 $1.42 $3.95
44 $1.82 $4.21 121 $1.37 $3.05 198 $2.82 $2.89 275 $2.41 $3.54 352 $2.58 $3.68
45 $1.55 $3.03 122 $1.73 $3.10 199 $2.58 $3.00 276 $2.56 $3.35 353 $2.22 $3.30
46 $2.20 $3.70 123 $1.76 $4.32 200 $1.61 $4.13 277 $1.75 $3.17 354 $1.54 $3.80
47 $1.65 $3.59 124 $2.32 $3.91 201 $1.76 $4.16 278 $2.54 $3.13 355 $2.74 $3.42
48 $2.77 $3.92 125 $2.41 $3.51 202 $1.87 $3.27 279 $1.63 $4.16 356 $2.00 $3.40
49 $1.55 $4.15 126 $2.25 $3.91 203 $1.56 $3.72 280 $2.10 $4.07 357 $1.38 $3.21
50 $2.28 $2.88 127 $2.77 $4.16 204 $2.24 $2.90 281 $1.39 $4.33 358 $2.81 $2.97
51 $2.21 $3.15 128 $2.78 $3.44 205 $1.58 $3.55 282 $2.34 $3.89 359 $1.61 $3.23
52 $1.37 $3.51 129 $2.09 $3.61 206 $1.37 $3.25 283 $2.77 $2.89 360 $2.69 $3.81
53 $2.08 $3.57 130 $2.34 $3.94 207 $1.39 $3.14 284 $1.68 $3.25 361 $1.46 $4.34
54 $2.53 $4.14 131 $2.44 $2.98 208 $2.57 $3.95 285 $2.44 $3.33 362 $1.68 $3.89
55 $1.48 $3.40 132 $2.81 $4.24 209 $2.67 $2.91 286 $2.04 $3.67 363 $2.48 $4.03
56 $1.93 $3.63 133 $1.69 $4.25 210 $1.71 $4.31 287 $2.33 $3.04 364 $2.35 $3.12
57 $2.76 $3.24 134 $1.47 $4.29 211 $2.33 $4.34 288 $1.37 $3.15 365 $1.73 $3.83
58 $1.98 $3.19 135 $1.58 $3.37 212 $2.29 $4.27 289 $2.61 $4.25 366 $2.64 $3.01
59 $1.45 $4.10 136 $2.28 $3.10 213 $2.66 $3.12 290 $1.49 $4.12 367 $2.15 $3.12
60 $2.44 $3.54 137 $2.03 $3.46 214 $1.62 $2.92 291 $2.27 $4.11 368 $2.21 $4.03
61 $2.07 $3.11 138 $1.77 $3.11 215 $1.36 $3.38 292 $1.87 $2.89 369 $2.33 $4.27
62 $2.62 $3.54 139 $1.58 $3.18 216 $1.48 $2.95 293 $1.72 $2.93 370 $2.05 $3.37
63 $1.58 $3.43 140 $1.45 $2.99 217 $2.56 $3.68 294 $2.01 $4.05 371 $1.53 $3.59
64 $2.38 $3.02 141 $1.93 $3.72 218 $2.12 $4.19 295 $1.64 $3.66 372 $2.82 $2.99
65 $2.51 $3.48 142 $1.42 $3.52 219 $1.68 $4.22 296 $1.83 $3.56 373 $1.68 $4.23
66 $1.71 $3.31 143 $1.64 $4.06 220 $2.01 $3.64 297 $2.61 $3.55 374 $2.32 $3.46
67 $1.36 $3.43 144 $1.91 $3.00 221 $1.42 $3.35 298 $2.15 $2.92 375 $1.61 $4.28
68 $2.53 $4.32 145 $2.11 $3.59 222 $1.92 $3.68 299 $2.07 $4.01 376 $1.95 $3.24
69 $2.16 $3.07 146 $2.10 $4.10 223 $1.40 $4.18 300 $2.44 $3.50 377 $2.20 $3.71
70 $1.74 $3.00 147 $1.40 $3.74 224 $2.65 $3.42 301 $1.89 $4.09 378 $2.34 $3.28
71 $2.07 $3.07 148 $2.11 $2.92 225 $1.36 $3.05 302 $1.46 $2.96 379 $2.26 $3.31
72 $1.68 $3.43 149 $2.11 $3.19 226 $1.58 $3.29 303 $2.47 $3.58 380 $1.96 $3.72
73 $2.37 $3.54 150 $2.82 $3.57 227 $1.44 $3.14 304 $2.52 $4.13 381 $2.04 $3.92
74 $1.91 $2.99 151 $2.73 $3.69 228 $1.44 $3.90 305 $2.32 $3.80 382 $2.82 $4.14
75 $1.50 $4.26 152 $2.62 $4.36 229 $1.99 $2.98 306 $2.67 $3.66 383 $1.42 $4.03
76 $2.40 $3.83 153 $2.71 $3.41 230 $1.78 $3.56 307 $2.48 $3.43 384 $1.39 $4.35
77 $2.26 $3.92 154 $2.62 $3.90 231 $2.62 $3.33 308 $2.41 $3.18 385 $2.74 $3.56
Paired two samples t-test for Means
t-Test: Paired Two Sample for Means
Total overhead cost Sales price
Mean 2.0819 3.5872
Variance 0.1965 0.1963
Observations 385 385
Pearson Correlation -0.0682
Hypothesized Mean Difference 0.0000
df 384.0000
t Stat -47.4375
P(T<=t) one-tail 0.0000
t Critical one-tail 1.6488
P(T<=t) two-tail 0.0000
t Critical two-tail 1.9662