Answered step by step
Verified Expert Solution
Question
1 Approved Answer
begin{tabular}{|c|c|c|c|c|c|c|c|c|} hline & A & B & C & D & E & F & G & H hline 1 & Customer & Expenditures
\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H \\ \hline 1 & Customer & Expenditures & & & & & & \\ \hline 2 & 1 & 1272 & & & & & & \\ \hline 3 & 2 & 1089 & & & & & & \\ \hline 4 & 3 & 1169 & & & & & & \\ \hline 5 & 4 & 1161 & & & & & & \\ \hline 6 & 5 & 1286 & & & & & & \\ \hline 7 & 6 & 1178 & & & & & & \\ \hline 8 & 7 & 658 & & & & & & \\ \hline 9 & 8 & 1685 & & & & & & \\ \hline 10 & 9 & 587 & & & & & & \\ \hline 11 & 10 & 1284 & & & & & & \\ \hline 12 & 11 & 1786 & & & & & & \\ \hline 13 & 12 & 1379 & & & & & & \\ \hline 14 & 13 & 1617 & & & & & & \\ \hline 15 & 14 & 1485 & & & & & & \\ \hline 16 & 15 & 1609 & & & & & & \\ \hline 17 & 16 & 1612 & & & & & & \\ \hline 18 & 17 & 1290 & & & & & & \\ \hline 19 & 18 & 715 & & & & & & \\ \hline 20 & 19 & 1261 & & & & & & \\ \hline 21 & 20 & 1249 & & & & & & \\ \hline 22 & 21 & 931 & & & & & & \\ \hline 23 & 22 & 1319 & & & & & & \\ \hline 24 & 23 & 1246 & & & & & & \\ \hline 25 & 24 & 1130 & & & & & & \\ \hline 26 & 25 & 1271 & & & & & & \\ \hline 27 & 26 & 1627 & & & & & & \\ \hline 28 & 27 & 1625 & & & & & & \\ \hline 29 & 28 & 1565 & & & & & & \\ \hline 30 & 29 & 2026 & & & & & & \\ \hline 31 & 30 & 1078 & & & & & & \\ \hline 32 & 31 & 751 & & & & & & \\ \hline 33 & 32 & 645 & & & & & & \\ \hline 34 & 33 & 1351 & & & & & & \\ \hline 35 & 34 & 1664 & & & & & & \\ \hline 36 & 35 & 887 & & & & & & \\ \hline 37 & 36 & 1091 & & & & & & \\ \hline 38 & 37 & 1203 & & & & & & \\ \hline 39 & 38 & 899 & & & & & & \\ \hline 40 & 39 & 1165 & & & & & & \\ \hline \end{tabular} The accompanylng data file shows the annual expenditures (In \$) for 100 Amazon Prime customers. -1. Calculate the mean. Note: Round final answer to the nearest whole number. Mean -2 Calculate the median. Note: Round final answer to the nearest whole number. Median b-1. Calculate the first quartlle for annual expenditures. Note: Round final answer to the nearest whole number. If you are using Excel, use the PERCENTILE.INC function to find the appropriate quartile. b-2. Interpret the first quartle for annual expenditures. Seventy-five percent of the customers spent less than $1,119,25% of the customers spent more than $1,119. Seventy-five percent of the customers spent less than $1,288,25% of the customers spent more than $1,288. Twenty-five percent of the customers spent less than $1,119,75% of the customers spent more than $1,119. Twenty-five percent of the customers spent less than 1,288,75% of the customers spent more than 1,288 . b-3. Calculate the third quartle for annual expenditures. Note: Round final answer to the nearest whole number. If you are using Excel, use the PERCENTILE.INC function to find the approprlate quartile. Third quartile b-4. Interpret the third quartle for annual expenditures. Seventy-five percent of the customers spent less than $1,574,25% of the customers spent more than $1,574. Seventy-five percent of the customers spent less than $1,307,25% of the customers spent more than $1,307. Twenty-five percent of the customers spent less than $1,574,75% of the customers spent more than $1,574. Twenty-five percent of the customers spent less than 1,307,75% of the customers spent more than 1,307
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