4. Find the first, second, and third quartiles for the sales amounts in the data provided and interpret the results. (Round to two decimal places as needed). The first quartile is$_____, meaning that __% of the sales amounts are less than this value. The second quartile is$_____, meaning that __% of the sales amounts are less than this value. The third quartile is$_____, meaning that __% of the sales amounts are less than this value.
4. Find the first, second, and third
The first quartile is$_____, meaning that __% of the sales amounts are less than this value.
The second quartile is$_____, meaning that __% of the sales amounts are less than this value.
The third quartile is$_____, meaning that __% of the sales amounts are less than this value.
(See picture)
4.
The first quartile can be obtained using the excel formula “=QUARTILE.EXC(A1:A38,1)”. From the Excel formula, the first quartile is 18.31.
Thus, the first quartile is $18.31, meaning that 25% of the sales amounts are less than this value.
The second quartile can be obtained using the excel formula “=QUARTILE.EXC(A1:A38,2)”. From the Excel formula, the second quartile is 18.31.
Thus, the first quartile is $20.17, meaning that 50% of the sales amounts are less than this value.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
