1. Use Baseball Players sheet to answer this question.
2. Use Score sheet to answer this question
The file BUS.xlsx, sheet named Score contains midterm (X axis) and final exam (Y axis) scores for 96 students in a corporate finance course. Do the students’ scores for the two exams tend to go together, so that those who do poorly on the midterm tend to do poorly on the final, and those who do well on the midterm tend to do well on the final? Create a scatterplot to answer this question. Use an appropriate titles for your plot including X axis and Y axis.
3. Use Temperatures sheet to answer this question.
The fileBUS.xlsx, sheet named Temperatures, shows daily high temperatures (in Fahrenheit) recorded in Alexandria, Virginia for the month of December, 2015.
a. Indicate the level of data measurements for temperatures. [Hint: whether nominal, ordinal, interval or ratio.]
b. Construct a frequency distribution table using 5 class intervals. Determine relative frequency, percent and cumulative percent for these data.
c. Using cumulative percent values in part (b), what percent of the times daily high temperatures was less than 63? [Do not calculate this value manually. Use part (b) to answer this question.]
d. Construct a histogram.
e. What does histogram tell us about the daily high temperature for the month of December, 2015?
[Note: Your answers – table, graph and any comment should be placed in Temperatures sheet. Do not create a new sheet or a new workbook. For (e), insert a text box. Type your comment inside the text box.]
4. Use Part-4 sheet to answer this question.
The file BUS.xlsx, sheet named Part-4 contains data from a survey of 399 people regarding a government environmental policy. Recode the data into a new data set, making one transformation: change Children to list “No children” or “At least one child”. Then create a column chart (so-called Bar chart) of counts for the new Children variable. Use an appropriate title for your chart. [Hint: Use if function]
5. Use Restaurant sheet to answer this question.
The file BUS.xlsx, sheet named Restaurant lists the times required to service 200 consecutive customers at a (fictional) fast-food restaurant. Use the data to construct a box-and-whisker plot. Discuss the skewness of the distribution of these data and point out any outlier(s).
6. Use Top 50 Grad Programs sheet to answer this question.
The file BUS.xlsx, sheet named Top 50 Grad Programs includes data on the 50 top graduate programs in the United States, according to a 2009 U.S. News & World Report survey.
a. Indicate the level of data measurements for Out-of-State tuition and fee levels. [Hint: whether nominal, ordinal, interval or ratio.]
b. Calculate the largest (max) and smallest (min) annual out-of-state tuition and fee levels.
c. Find the annual out-of-state tuition and fee levels at each of the 25th, and 75th percentiles for these schools.
[Note: Your answers should be placed in Top 50 Grad Programs sheet. Do not create a new sheet or a new workbook.]
7. Use Salary sheet to answer this question.
The file BUS.xlsx, sheet named Salary contains salaries of 200 recent graduates from a (fictional) MBA program. Assume these are sample data.
(a) If the empirical rules apply here, between which two numbers can you be about 68% sure that the salary of any one of these 200 students will fall? Do the empirical rules for standard deviations apply to these data?
(b) If you increased every graduate’s salary by $1000, what would happen to the standard deviation of the salaries? In order to receive full credit, you must justify your answer.
8. Use CEO Pay sheet to answer this question.
The Wall Street Journal CEO Compensation Study analyzed CEO pay from many U.S. companies with fiscal year 2008 revenue of at least $5 billion that filed their proxy statements between October 2008 and March 2009. The data are in the file Exam-1.xlsx, sheet named CEO Pay. Recode the data into a new data set, making one transformation: create a new variable called Total Compensation = Salary 2008 + Bonus 2008. Using this newly recoded Total Compensation variable, answer the following questions:
a. Calculate the values of mean, and median for Total Compensation.
b. Calculate the skewness for Total Compensation (Use Excel function SKEW). Is the distribution of the Total Compensation skewed? Negatively (left) or positively (right)?
c. Based on your answer for part (b), which measures, mean or median, should be used as a measure of central tendency? Why?
Quincy3900
BUSSTATISTICS.docx
0
