(Solved) Case 2 Foxtrot Inn Jane and Joe Millar run the Foxtrot Inn, a Bed and Breakfast Inn, located in Tryon, North Carolina. The business has eight rooms.


Question: Case 2     Foxtrot Inn

Jane and Joe Millar run the Foxtrot Inn, a Bed and Breakfast Inn, located in Tryon, North Carolina. The business has eight rooms.

Then you will see the number of these eight rooms rented daily during June 2011 appears.

June Bedrooms in rent
1 0
2 2
3 3
4 2
5 3
6 4
7 2
8 3
9 4
10 7
11 3
12 4
13 4
14 4
15 7
16 0
17 5
18 3
19 6
20 2
21 3
22 2
23 3
24 6
25 0
26 4
27 1
28 1
29 3
30 3
  1. Use Excel to select a sample of ten nights of the month of June (Shows Excel table of random sampling generated)
  2. Performs a descriptive statistics analysis of rooms rented during the month (Show the analysis table) and answer the following from it:
    How much is the sample mean?
    What is the value of the error?
    What is the value of the standard deviation and the variance?
    What is the mode and median?
    What is the range?
    What is the minimum and maximum value of the sample?
  3. Make a histogram of the sample (rooms for rent).

Price: $2.99
Solution: The downloadable solution consists of 4 pages
Deliverable: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in