3 questions in one Excel but each question in separate sheet, statistics homework help

User Generated

ArjFxl123

Mathematics

Description

3 questions in one Excel but each question in separate sheet.

Unformatted Attachment Preview

63. USA Today reports that NCAA colleges and universities are paying higher salaries to a newly recruited football coach compared to what they paid their previous football coach. (USA Today, February 12, 2013). The annual base salaries for the previous head football coach and the new head football coach at 23 schools are given in the file Coaches. a. Determine the median annual salary for a previous head football coach and a new head football coach. b. Compute the range for salaries for both previous and new head football coaches. c. Compute the standard deviation for salaries for both previous and new head football coaches. d. Based on your answers to (a) to (c), comment on any differences between the annual base salary a school pays a new head football coach compared to what it paid its pervi- ous head football coach. 67. Public transportation and the automobile are two methods an employee can use to get to work each day. Samples of times recorded for each method are shown. Times are in minutes. e 37 Public Transportation: 28 Automobile: 29 29 31 32 33 33 34 25 30 29 31 32 32 41 35 34 33 32 ion a. b. c. Compute the sample mean time to get to work for each method. Compute the sample standard deviation for each method. On the basis of your results from parts (a) and (b), which method of transportation should be preferred? Explain. Develop a box plot for each method. Does a comparison of the box plots support your conclusion in part (c)? d. ment. CO 70. Travel + Leisure magazine presented its annual list of the 500 best hotels in the world (Travel + Leisure, January 2009). The magazine provides a rating for each hotel along with a brief description that includes the size of the hotel, amenities, and the cost per night for a double room. A sample of 12 of the top-rated hotels in the United States follows. Location Rooms Cost/Night Hotel WEB file Boulders Resort & Spa Disney's Wilderness Lodge Four Seasons Hotel Beverly Hills Four Seasons Hotel Hay-Adams Inn on Biltmore Estate Loews Ventana Canyon Resort Mauna Lani Bay Hotel Montage Laguna Beach Sofitel Water Tower St. Regis Monarch Beach The Broadmoor Phoenix, AZ Orlando, FL Los Angeles, CA Boston, MA Washington, DC Asheville, NC Phoenix, AZ Island of Hawaii Laguna Beach, CA Chicago, IL Dana Point, CA Colorado Springs, CO 220 727 285 273 145 213 398 343 250 499 340 585 495 495 279 279 455 595 367 675 420 Travel a. c. What is the mean number of rooms? b. What is the mean cost per night for a double room? Develop a scatter diagram with the number of rooms on the horizontal axis and the cost per night on the vertical axis. Does there appear to be a relationship between the number of rooms and the cost per night? Discuss. d. What is the sample correlation coefficient? What does it tell you about the relationship between the number of rooms and the cost per night for a double room? Does this appear reasonable? Discuss.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

If the above file is not complete, this one will be.

Old Coaches New Coaches
3093125
5382734 Median Old
3217934 dollars
2394857
6832938 Median New
7381037 dollars
1027349
4928713 Range Old
6043366 dollars
904837
6493054 Range New
5513064 dollars
4039183
9385732 STD DEV Old
1819529 dollars
6948203
4324398 STD DEV New
1710811 dollars
2938...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags