Concept explainers
a.
Find the Mean and Standard deviation.
a.
Answer to Problem 85CE
The Mean and Standard deviation is:
Measures | Week 1 | Week 2 | Week 3 | Week 4 |
Mean | 50 | 50 | 50 | 50 |
Standard deviation | 10.61 | 10.61 | 10.61 | 10.61 |
Explanation of Solution
Calculation:
The data represents the weekend occupancy rates in the nine resort hotels at the time of off season.
For Week 1:
Mean:
Software procedure:
Step-by-step software procedure to obtain Mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column I in cells I1 to I9.
- In cell A1, enter the formula “=AVERAGE(I1:I9)”.
- Output using EXCEL software is given below:
Thus, the mean for Week 1 is 50.
Standard deviation:
Software procedure:
Step-by-step software procedure to obtain Standard deviation using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column I in cells I1 to I9.
- In cell A1, enter the formula “=STDEV(I1:19)”.
- Output using EXCEL software is given below:
Thus, the Standard deviation for Week 1 is 10.61.
For Week 2:
Mean:
Software procedure:
Step-by-step software procedure to obtain Mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column J in cells J1 to J9.
- In cell A1, enter the formula “=AVERAGE(J1:J9)”.
- Output using EXCEL software is given below:
Thus, the mean for the week 2 is 50.
Standard deviation:
Software procedure:
Step-by-step software procedure to obtain Standard deviation using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column J in cells J1 to J9.
- In cell A1, enter the formula “=STDEV(J1:J9)”.
- Output using EXCEL software is given below:
Thus, the Standard deviation for Week 2 is 10.61.
For Week 3:
Mean:
Software procedure:
Step-by-step software procedure to obtain Mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column K in cells K1 to K9.
- In cell A1, enter the formula “=AVERAGE(K1:K9)”.
- Output using EXCEL software is given below:
Thus, the mean for Week 3 is 50.
Standard deviation:
Software procedure:
Step-by-step software procedure to obtain Standard deviation using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column K in cells K1 to K9.
- In cell A1, enter the formula “=STDEV(K1:K9)”.
- Output using EXCEL software is given below:
Thus, the Standard deviation for Week 3 is 10.61.
For Week 4:
Mean:
Software procedure:
Step-by-step software procedure to obtain Mean using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column L in cells L1 to L9.
- In cell A1, enter the formula “=AVERAGE(L1:L9)”.
- Output using EXCEL software is given below:
Thus, the mean for Week 4 is 50.
Standard deviation:
Software procedure:
Step-by-step software procedure to obtain standard deviation using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column L in cells L1 to L9.
- In cell A1, enter the formula “=STDEV(L1:L9)”.
- Output using EXCEL software is given below:
Thus, the Standard deviation for Week 4 is 10.61.
b.
Write the conclusion based on the measures of center and variability.
b.
Explanation of Solution
By observing the values of mean and standard deviation, it states that the occupancy rate in the hotels is same for all the week ends during offseason. Therefore, it can be concluded that the distribution of the occupancy rate is normal.
c.
Calculate the
c.
Answer to Problem 85CE
The Median for the occupancy rates is:
Measures | Week 1 | Week 2 | Week 3 | Week 4 |
Median | 50 | 52 | 56 | 47 |
Explanation of Solution
For Week 1:
Median:
Software procedure:
Step-by-step software procedure to obtain Median using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column I in cells I1 to I9.
- In cell A1, enter the formula “=MEDIAN(I1:19)”.
- Output using EXCEL software is given below:
Thus, the median for Week 1 is 50.
For Week 2:
Median:
Software procedure:
Step-by-step software procedure to obtain Median using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column J in cells J1 to J9.
- In cell A1, enter the formula “=MEDIAN(J1:J9)”.
- Output using EXCEL software is given below:
Thus, the median for Week 2 is 52.
For Week 3:
Median:
Software procedure:
Step-by-step software procedure to obtain Median using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column K in cells K1 to K9.
- In cell A1, enter the formula “=MEDIAN(K1:K9)”.
- Output using EXCEL software is given below:
Thus, the median for Week 3 is 56.
For Week 4:
Median:
Software procedure:
Step-by-step software procedure to obtain Median using EXCEL software is as follows:
- Open an EXCEL file.
- Enter the data in the column L in cells L1 to L9.
- In cell A1, enter the formula “=MEDIAN(L1:L9)”.
- Output using EXCEL software is given below:
Thus, the median for Week 4 is 47.
d.
Construct dot plot for each sample.
d.
Answer to Problem 85CE
The dot plot for Week 1 is as follows:
The dot plot for Week 2 is as follows:
The dot plot for Week 3 is as follows:
The dot plot for Week 4 is as follows:
Explanation of Solution
Dot plot:
Procedure to draw a dot plot for Week 1:
- Draw a horizontal line and mark the points from 30 to 70 with 5-point scale
- For week 1, mark a point corresponding to each observation along the horizontal line.
Procedure to draw a dot plot for Week 2:
- Draw a horizontal line and mark the points from 30 to 70 with 5-point scale
- For week 2, mark a point corresponding to each observation along the horizontal line.
Procedure to draw a dot plot for Week 3:
- Draw a horizontal line and mark the points from 36 to 64 with 4-point scale
- For week 3, mark a point corresponding to each observation along the horizontal line.
Procedure to draw a dot plot for Week 4:
- Draw a horizontal line and mark the points from 35 to 70 with 5-point scale
- For week 4, mark a point corresponding to each observation along the horizontal line.
Thus, the dot plot has been obtained for Week 1, Week 2, Week 3 and Week 4.
e.
Describe the things that have been learnt from the median and dot plot, that was not apparent from the means and standard deviation.
e.
Explanation of Solution
The distribution of the occupancy rate is normal based on the value of mean and standard deviation. However, the median value and dot plot states that the distribution of the occupancy rate is little bit different.
Want to see more full solutions like this?
Chapter 4 Solutions
Applied Statistics in Business and Economics
- Good explanation it sure experts solve itarrow_forwardBest explains it not need guidelines okkarrow_forwardActiv Determine compass error using amplitude (Sun). Minimum number of times that activity should be performed: 3 (1 each phase) Sample calculation (Amplitude- Sun): On 07th May 2006 at Sunset, a vessel in position 10°00'N 010°00'W observed the Sun bearing 288° by compass. Find the compass error. LMT Sunset: LIT: (+) 00d 07d 18h 00h 13m 40m UTC Sunset: 07d 18h 53m (added- since longitude is westerly) Declination (07d 18h): N 016° 55.5' d (0.7): (+) 00.6' Declination Sun: N 016° 56.1' Sin Amplitude = Sin Declination/Cos Latitude = Sin 016°56.1'/ Cos 10°00' = 0.295780189 Amplitude=W17.2N (The prefix of amplitude is named easterly if body is rising, and westerly if body is setting. The suffix is named same as declination) True Bearing=287.2° Compass Bearing= 288.0° Compass Error = 0.8° Westarrow_forward
- Only sure experts solve it correct complete solutions okkarrow_forward13. In 2000, two organizations conducted surveys to ascertain the public's opinion on banning gay men from serving in leadership roles in the Boy Scouts.• A Pew poll asked respondents whether they agreed with "the recent decision by the Supreme Court" that "the Boy Scouts of America have a constitutional right to block gay men from becoming troop leaders."A Los Angeles Times poll asked respondents whether they agreed with the following statement: "A Boy Scout leader should be removed from his duties as a troop leader if he is found out to be gay, even if he is considered by the Scout organization to be a model Boy Scout leader."One of these polls found 36% agreement; the other found 56% agreement. Which of the following statements is true?A) The Pew poll found 36% agreement, and the Los Angeles Times poll found 56% agreement.B) The Pew poll includes a leading question, while the Los Angeles Times poll uses neutral wording.C) The Los Angeles Times Poll includes a leading question, while…arrow_forwardAnswer questions 2arrow_forward
- (c) Give an example where PLANBAC)= PCAPCBIPCC), but the sets are not pairwise independentarrow_forwardScrie trei multiplii comuni pentru numerele 12 și 1..arrow_forwardIntroduce yourself and describe a time when you used data in a personal or professional decision. This could be anything from analyzing sales data on the job to making an informed purchasing decision about a home or car. Describe to Susan how to take a sample of the student population that would not represent the population well. Describe to Susan how to take a sample of the student population that would represent the population well. Finally, describe the relationship of a sample to a population and classify your two samples as random, systematic, cluster, stratified, or convenience.arrow_forward
- 1.2.17. (!) Let G,, be the graph whose vertices are the permutations of (1,..., n}, with two permutations a₁, ..., a,, and b₁, ..., b, adjacent if they differ by interchanging a pair of adjacent entries (G3 shown below). Prove that G,, is connected. 132 123 213 312 321 231arrow_forwardYou are planning an experiment to determine the effect of the brand of gasoline and the weight of a car on gas mileage measured in miles per gallon. You will use a single test car, adding weights so that its total weight is 3000, 3500, or 4000 pounds. The car will drive on a test track at each weight using each of Amoco, Marathon, and Speedway gasoline. Which is the best way to organize the study? Start with 3000 pounds and Amoco and run the car on the test track. Then do 3500 and 4000 pounds. Change to Marathon and go through the three weights in order. Then change to Speedway and do the three weights in order once more. Start with 3000 pounds and Amoco and run the car on the test track. Then change to Marathon and then to Speedway without changing the weight. Then add weights to get 3500 pounds and go through the three gasolines in the same order.Then change to 4000 pounds and do the three gasolines in order again. Choose a gasoline at random, and run the car with this gasoline at…arrow_forwardAP1.2 A child is 40 inches tall, which places her at the 90th percentile of all children of similar age. The heights for children of this age form an approximately Normal distribution with a mean of 38 inches. Based on this information, what is the standard deviation of the heights of all children of this age? 0.20 inches (c) 0.65 inches (e) 1.56 inches 0.31 inches (d) 1.21 inchesarrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL