Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Process To Profits Strategic Planning For A Growing Business

Authors: William Lasher

1st Edition

0324223870, 9780324223873

More Books

Students also viewed these Finance questions