Author Question: The Carter Department Store has data on the sales volume by department for the past 200 days. The ... (Read 111 times)

KimWrice · **on:** Jun 24, 2018

The Carter Department Store has data on the sales volume by department for the past 200 days. The data are in an Excel spreadsheet where column A represents the department name and column B represents the sales for each day in that department.

In order to construct a bar chart that illustrates the difference in total sales by department for the 200 days, a required step in Excel will be to:A) determine the total sales by department.
B) use the frequency function to count the number of occurrences by department.
C) group the data into 5 to 20 classes.
D) determine the class widths.

Question 2

A golf course in California has determined that the mean time it takes for a foursome to complete an 18 hole round of golf is 4 hours 35 minutes (275 minutes) with a standard deviation of 14 minutes.

The time distribution is also thought to be approximately normal. Every month, the head pro at the course randomly selects a sample of 8 foursomes and monitors the time it takes them to play. Suppose the mean time that was observed for the sample last month was 4 hours 44 minutes (284 minutes). What is the probability of seeing a sample mean this high or higher?A) Approximately 0.4649
B) About 0.9649
C) Approximately 0.0351
D) About 0.9298