Purchase Solution

Statistics for Managers Using Microsoft Excel

Not what you're looking for?

Ask Custom Question

The data in the file protein.xls indicate fat and cholesterol information concerning popular protein foods (fresh red meats, poultry, and fish).

For the data relating to the number of calories and the amount of cholestrol for the popular protein foods:

a. Consruct a frequency distribution and a percentage distribution.

b. Construct a histogram and a percentage polygon.

c. Form a cumulative percentage distribution and plot a cumulative percentage polygon.

d. What conclusions can you draw from these analyses?

Attachments
Purchase this Solution
Solution Summary

This solution constructs a frequency distribution, percentage distribution, histogram, percentage polygon and also prepares and cumulative percentage distribution and cumulative percentage polygon. It also interprets the result of the popular protein foods from the graphs.

Solution Preview

Statistics for Managers Using Microsoft Excel Ch.2 2.78
The data in the file protein.xls indicate fat and cholesterol information concerning popular protein foods (fresh red meats, poultry, and fish).

For the data relating to the number of calories and the amount of cholestrol for the popular protein foods:
a. Consruct a frequency distribution and a percentage distribution.
b. Construct a histogram and a percentage polygon.
c. Form a cumulative percentage distribution and plot a cumulative percentage polygon.
d. What conclusions can you draw from these analyses?
Solution:
a.
Frequency Distribution - Quantitative

Calories
lower upper midpoint width frequency percent
60 < 90 75 30 0 0.0
90 < 120 105 30 6 24.0
120 < 150 135 30 0 0.0
150 < 180 165 30 2 8.0
180 < 210 195 30 8 32.0
210 < 240 ...

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Develop a regression model for new subscriptions

    299108 Statistics for Managers: SH13.3 Develop a regression model for new subscriptions See attached files. From Statistics for Managers Using Microsoft® Excel, Fifth Edition: SH13.3 a.

  • Utilizing MS Excel and SPSS in Managerial Decision-Making

    593110 Utilizing MS Excel and SPSS in Managerial Decision-Making Research Microsoft Excel, the statistical package for the social sciences (SPSS), and the legal and ethical aspects of surveys and data collection.

  • Calculation of Descriptive Statistics using the Excel

    Step by step solution is attached for better understanding and clarity to this problem. This solution is comprised of a detailed explanation of descriptive statistics using the Microsoft Excel.

  • Statistics for Managers - Qns 8-67, 9-89, 10-67, 11-11,12-67

    This is very urgent ASAP please Thank u ps: I need the answers to the following questions from the book: Statistics for managers using Microsoft excel 5th edition Problem: Question 8-67: Companies are spending more time screening applicants

  • Project Management and the use of project management tools

    www.cse.psu.edu/~lambert/420/big/node89.html In other word, Project Management tools track the progress of the project using the information using information from Excel, MS project, etc.

  • Tools for project risk management

    In fact, Microsoft Project is the most commonly used tool for project risk management. Microsoft Project can also be used along with Excel for more flexible work environment.

  • Descriptive Statistics for AIU Data Set

    Please see the answers Step by step method for computing descriptive Statistics in Excel for AIU data set is given in the answer.

  • Statistics

    Using the data listed above in problem 1, calculate by hand the standard deviation. b. Using Microsoft Excel, type 'Ratings' in column A, cell 1. Below cell one, start typing your data in the A column. c.

  • Project Management Tools.

    How could you use spreadsheets, such as Microsoft Excel? How could you use scheduling tools, such as Microsoft Project? Share some tips for using either of these products.

View More Related Solutions