The Carter Department Store has data on the sales volume by ...

[KimWrice]

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

[jaaaaaaa]

Answer to Question 1

A

Answer to Question 2

C

[KimWrice]

Excellent

[yeungji]

Gracias!