The Following Data Represent The Total Grocery Bill In Dollars For A Sample Of 24 Customers At A Local Grocery Store 1 (52.7 KiB) Viewed 10 times
The Following Data Represent The Total Grocery Bill In Dollars For A Sample Of 24 Customers At A Local Grocery Store 2 (33.24 KiB) Viewed 10 times
The following data represent the total grocery bill (in dollars) for a sample of 24 customers at a local grocery store. 85 90 110 115 128 130 130 144 150 161 163 165 168 170 175 180 180 188 190 196 198 201 210 220 Complete this question in Excel and submit your spreadsheet for marking. Round your answers to 2 decimal place a. Use the percentile locator formula to determine the quartiles (not intuitive). Q1 = Q2 = Q3 = 0 0 0
b. Determine the interquartile range. IQR: c. Determine the lower and upper limits for outliers. Lower limit: Upper Limit: 0 85 90 d. Identify outliers in the data, or state none if applicable. O 210 O 220 0 0
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!