For questions (a) and (b), students are required to do calculations in Excel.
For questions (d), students are to use theboxplot makerfor this assignment.
These graphs are to be copied/pasted in a Word documents. Students are required to write at least a 3 sentence explanation each for parts (c) to (e)
Directions for submitting your written assignment as an attachment:
1. When you have completed the written assignment, save the file on your computer with your name as part of the file name, for example: a_student_assignment1.doc [using
your
first initial and last name]
2. Click on the title of the assignment above.
3. Click on the "Browse My Computer" button to attachyour fileto this assignment.
4. Once you have attached your file, click on the "Submit" button to send your file to your instructor for grading.
Use the HotelPrices data set (attached) and answer the following questions:
What was the average price of a room at two-star, three-star and four-star hotels around the world during the first half of 2013. The dataset contains prices in English pounds . Complete the following for the two-star, three-star and four-star hotels.
a. Compute the mean, median, first quartile and third quartile.
b. Compute the range, interquartile range, variance, standard deviation and coefficient of variation.
c. Interpret the measures of central tendency and variation within the context of this problem.
d. Construct a boxplot. Are the data skewed. If so, how?
e. Based on the results of (a) through (c), what conclusions can you reach concerning these variables?For questions (a) and (b), students are required to do calculations in Excel.
For questions (d), students are to use theboxplot makerfor this assignment.
These graphs are to be copied/pasted in a Word documents. Students are required to write at least a 3 sentence explanation each for parts (c) to (e)
Directions for submitting your written assignment as an attachment:
1. When you have completed the written assignment, save the file on your computer with your name as part of the file name, for example: a_student_assignment1.doc [using
your
first initial and last name]
2. Click on the title of the assignment above.
3. Click on the "Browse My Computer" button to attachyour fileto this assignment.
4. Once you have attached your file, click on the "Submit" button to send your file to your instructor for grading.
Use the HotelPrices data set (attached) and answer the following questions:
What was the average price of a room at two-star, three-star and four-star hotels around the world during the first half of 2013. The dataset contains prices in English pounds . Complete the following for the two-star, three-star and four-star hotels.
a. Compute the mean, median, first quartile and third quartile.
b. Compute the range, interquartile range, variance, standard deviation and coefficient of variation.
c. Interpret the measures of central tendency and variation within the context of this problem.
d. Construct a boxplot. Are the data skewed. If so, how?
e. Based on the results of (a) through (c), what conclusions can you reach concerning these variableFor questions (a) and (b), students are required to do calculations in Excel.
For questions (d), students are to use theboxplot makerfor this assignment.
These graphs are to be copied/pasted in a Word documents. Students are required to write at least a 3 sentence explanation each for parts (c) to (e)
Directions for submitting your written assignment as an attachment:
1. When you have completed the written assignment, save the file on your computer with your name as part of the file name, for example: a_student_assignment1.doc [using
your
first initial and last name]
2. Click on the title of the assignment above.
3. Click on the "Browse My Computer" button to attachyour fileto this assignment.
4. Once you have attached your file, click on the "Submit" button to send your file to your instructor for grading.
Use the HotelPrices data set (attached) and answer the following questions:
What was the average price of a room at two-star, three-star and four-star hotels around the world during the first half of 2013. The dataset contains prices in English pounds . Complete the following for the two-star, three-star and four-star hotels.
a. Compute the mean, median, first quartile and third quartile.
b. Compute the range, interquartile range, variance, standard deviation and coefficient of variation.
c. Interpret the measures of central tendency and variation within the context of this problem.
d. Construct a boxplot. Are the data skewed. If so, how?
e. Based on the results of (a) through (c), what conclusions can you reach concerning these variables?s?