Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please download the file final.xlsx and refer to Worksheet A. The standard deviation (assume that the dataset represents a sample, not a population) of the
Please download the file final.xlsx and refer to Worksheet A. The standard deviation (assume that the dataset represents a sample, not a population) of the quantity sold per transaction is ________. Round your answer to the nearest whole number, and enter just the number; e.g., enter 71.5 as 72.
Transaction number | Quantity | Unit price | Total |
23 | 149 | $ 19.08 | $ 2,842.92 |
47 | 149 | $ 34.19 | $ 5,094.31 |
76 | 147 | $ 39.51 | $ 5,807.97 |
6 | 146 | $ 26.50 | $ 3,869.00 |
11 | 145 | $ 31.59 | $ 4,580.55 |
80 | 144 | $ 25.35 | $ 3,650.40 |
33 | 142 | $ 37.66 | $ 5,347.72 |
37 | 140 | $ 20.60 | $ 2,884.00 |
29 | 139 | $ 35.56 | $ 4,942.84 |
50 | 139 | $ 23.63 | $ 3,284.57 |
58 | 138 | $ 27.55 | $ 3,801.90 |
67 | 138 | $ 20.53 | $ 2,833.14 |
85 | 136 | $ 31.82 | $ 4,327.52 |
4 | 135 | $ 36.52 | $ 4,930.20 |
25 | 135 | $ 32.38 | $ 4,371.30 |
95 | 135 | $ 39.62 | $ 5,348.70 |
55 | 134 | $ 32.12 | $ 4,304.08 |
57 | 132 | $ 17.44 | $ 2,302.08 |
35 | 130 | $ 39.23 | $ 5,099.90 |
34 | 129 | $ 38.06 | $ 4,909.74 |
13 | 128 | $ 35.99 | $ 4,606.72 |
96 | 126 | $ 35.36 | $ 4,455.36 |
53 | 125 | $ 28.58 | $ 3,572.50 |
70 | 122 | $ 33.43 | $ 4,078.46 |
78 | 120 | $ 22.40 | $ 2,688.00 |
100 | 120 | $ 33.78 | $ 4,053.60 |
20 | 118 | $ 30.81 | $ 3,635.58 |
46 | 118 | $ 29.14 | $ 3,438.52 |
30 | 114 | $ 38.92 | $ 4,436.88 |
89 | 113 | $ 32.29 | $ 3,648.77 |
72 | 112 | $ 19.82 | $ 2,219.84 |
2 | 110 | $ 22.68 | $ 2,494.80 |
87 | 106 | $ 28.49 | $ 3,019.94 |
17 | 104 | $ 22.55 | $ 2,345.20 |
69 | 101 | $ 34.04 | $ 3,438.04 |
19 | 100 | $ 20.04 | $ 2,004.00 |
54 | 100 | $ 32.98 | $ 3,298.00 |
43 | 98 | $ 28.63 | $ 2,805.74 |
83 | 98 | $ 38.76 | $ 3,798.48 |
12 | 97 | $ 20.70 | $ 2,007.90 |
28 | 97 | $ 26.87 | $ 2,606.39 |
45 | 97 | $ 24.48 | $ 2,374.56 |
26 | 95 | $ 34.21 | $ 3,249.95 |
65 | 93 | $ 25.10 | $ 2,334.30 |
91 | 93 | $ 33.51 | $ 3,116.43 |
8 | 92 | $ 29.92 | $ 2,752.64 |
14 | 91 | $ 38.48 | $ 3,501.68 |
90 | 89 | $ 20.62 | $ 1,835.18 |
48 | 88 | $ 22.96 | $ 2,020.48 |
49 | 88 | $ 17.40 | $ 1,531.20 |
98 | 87 | $ 25.64 | $ 2,230.68 |
44 | 85 | $ 32.39 | $ 2,753.15 |
97 | 85 | $ 33.44 | $ 2,842.40 |
16 | 84 | $ 31.21 | $ 2,621.64 |
31 | 83 | $ 39.77 | $ 3,300.91 |
7 | 81 | $ 38.76 | $ 3,139.56 |
32 | 81 | $ 25.48 | $ 2,063.88 |
3 | 79 | $ 22.84 | $ 1,804.36 |
10 | 75 | $ 20.35 | $ 1,526.25 |
1 | 73 | $ 32.41 | $ 2,365.93 |
36 | 71 | $ 35.38 | $ 2,511.98 |
92 | 71 | $ 18.95 | $ 1,345.45 |
66 | 70 | $ 39.56 | $ 2,769.20 |
73 | 70 | $ 19.08 | $ 1,335.60 |
88 | 70 | $ 24.42 | $ 1,709.40 |
9 | 69 | $ 20.93 | $ 1,444.17 |
41 | 67 | $ 32.32 | $ 2,165.44 |
51 | 66 | $ 24.81 | $ 1,637.46 |
64 | 66 | $ 34.73 | $ 2,292.18 |
79 | 66 | $ 39.72 | $ 2,621.52 |
81 | 64 | $ 29.06 | $ 1,859.84 |
22 | 63 | $ 33.95 | $ 2,138.85 |
56 | 62 | $ 38.24 | $ 2,370.88 |
27 | 60 | $ 36.79 | $ 2,207.40 |
40 | 60 | $ 29.31 | $ 1,758.60 |
59 | 60 | $ 19.46 | $ 1,167.60 |
21 | 58 | $ 34.82 | $ 2,019.56 |
61 | 58 | $ 29.08 | $ 1,686.64 |
86 | 55 | $ 24.60 | $ 1,353.00 |
99 | 55 | $ 35.06 | $ 1,928.30 |
5 | 54 | $ 18.31 | $ 988.74 |
84 | 54 | $ 31.94 | $ 1,724.76 |
77 | 51 | $ 21.65 | $ 1,104.15 |
18 | 48 | $ 28.48 | $ 1,367.04 |
68 | 48 | $ 31.35 | $ 1,504.80 |
82 | 46 | $ 17.37 | $ 799.02 |
52 | 44 | $ 37.52 | $ 1,650.88 |
75 | 44 | $ 17.24 | $ 758.56 |
15 | 43 | $ 17.36 | $ 746.48 |
39 | 43 | $ 32.32 | $ 1,389.76 |
38 | 42 | $ 39.16 | $ 1,644.72 |
62 | 39 | $ 32.21 | $ 1,256.19 |
71 | 38 | $ 32.32 | $ 1,228.16 |
24 | 37 | $ 29.68 | $ 1,098.16 |
60 | 37 | $ 22.93 | $ 848.41 |
42 | 33 | $ 32.47 | $ 1,071.51 |
74 | 30 | $ 26.42 | $ 792.60 |
63 | 26 | $ 37.43 | $ 973.18 |
93 | 26 | $ 23.14 | $ 601.64 |
94 | 25 | $ 26.29 | $ 657.25 |
Step 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