Excel problems dealing with numbers and percentage

I need an explanation for this Excel question to help me study.

Haven’t Found The Relevant Content? Hire a Subject Expert to Help You With
Excel problems dealing with numbers and percentage
Hire Writer

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.

superadmin (28431)
New York University

Hire an Expert to Help you

Hire Verified Expert

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Have a homework question? Get help from verified tutors now!

Are You Looking For Assignment Help? We Can Certainly Assist You