# Excel problems dealing with numbers and percentage

__There are four questions with multiple parts__

- Use
**Baseball Players**sheet to answer this question. - Use
**Score**sheet to answer this question - Use
**Temperatures**sheet to answer this question.- Indicate the level of data measurements for temperatures. [Hint: whether nominal, ordinal, interval or ratio.]

- Use
**Part-4**sheet to answer this question.

The file **Exam_1.xlsx****, sheet named Baseball Players**** , **contains salary data on all Major League Baseball players for year 2011. Create a table of counts of the various positions, then express as percentage of all players for the year. Construct 2 charts: (1) create a column chart (so-called Bar) of counts, and (2) create a pie chart of these percentages for the year. Use an appropriate title for your charts. Which chart you prefer ā Column or Pie? Why? Which position is most common? [Note: Your answers ā table, graphs and any comment should be placed in

**Baseball Players**sheet. Do not create a new sheet or a new workbook.]

The file **Exam_1.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.

The file **Exam_1.xlsx****, sheet named Temperatures****, shows **daily high temperatures (in Fahrenheit) recorded in Alexandria, Virginia for the month of December, 2015.

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.]

The file **Exam_1.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.

I have an attachment for the numbers and the Excel sheets.