Advertising Age annually compiles a list of the 100 companies that spend the most on advertising. Consumer-goods company Procter & Gamble has often topped the list, spending billions of dollars annually. The data on annual advertising expenditures for a sample of 20 companies in the automotive sector and 20 companies in the department store sector are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.
2
The Russell 1000 is a stock market index consisting of the largest U.S. companies. The Dow Jones industrial Average is based on 30 large companies. The data giving the annual percentage returns for each of these stock indexes for 25 years are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.
3
The Russell 1000 is a stock market index consisting of the largest U.S. companies. The Dow Jones industrial Average is based on 30 large companies. The data giving the annual percentage returns for each of these stock indexes for 25 years are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.
4
The average waiting time for a patient at an El Paso physicians office is just over 29 minutes, well above the national average of 21 minutes. In fact, El Paso has the longest physicians office waiting times in the United States. In order to address the issue of long patient wait times, some physicians offices are using wait tracking systems to notify patients of expected wait times. Patients can adjust their arrival times based on this information and spend less time in waiting rooms. The Excel Online file below contains the data showing wait times (minutes) for a sample of patients at offices that do not have an office tracking system and wait times for a sample of patients at offices with an office tracking system. Construct a spreadsheet to answer the following questions.
5
Naples, Florida, hosts a half-marathon (13.1-mile race) in January each year. The event attracts top runners from throughout the United States as well as from around the world. 22 men and 31 women entered the 19-24 age class. Finish times in minutes are contained in order of finish in the Excel Online file below. Construct a spreadsheet to answer the following questions.
Outliers in the women’s group.
