Purchase Solution

MGMT 650 Q4 Frequency, Q5 Charts

Not what you're looking for?

Ask Custom Question

Q4 - Frequency
Use the raw Data on the Pivot Table Data Sheet to create a Frequency Chart:
Follow these steps to get the Frequency chart. The following website also has instructions to create bins.
13) Step One: (Find the lowest and highest numbers in the data.) Use the Excel sheet titled Pivot Table Data
What is the Total DomesticGross of the lowest movie sales? Hint - use either =MIN()or just choose the movie at the bottom of the list
What is the Total DomesticGross of the highest movie sales? Hint - use either =MAX()or just choose the movie at the top of the list
Step Two: (Find the range)
Step Three: (Find the bin widths)
Each bin will be : wide. Do not round.
Step Four: (Find the highest number for the first bin by starting with the lowest number in the data set and adding the bin width.)
Start with the minimum number:
Add the width of the bins
This number is the highest number that is used in the first bin.
Excel will use this number when it counts the number of pieces of data in the raw data set that is lower than this number.
Put this number in cell C36 for the first bin.
Step Five: (Find the rest of the highest bin numbers. Start with the highest number in the first bin. Add the bin width. This number is the highest total for bin 2.)
Therefore, the second bin begins with and adds the bin size to get
Successive bins start with the previous bin's highest number and adds the width of the bins. The last bin will have the maximum number in the data set as its highest value.
Therefore, continue adding to get the Bins array for the =FREQUENCY() function.
The last bin number in cell C45 will equal the highest Domestic Gross movie total
14) Here are the highest numbers for each bin:
15) Follow the instructions in the youtube videos to use the =FREQUENCY() array function.
You know that you have correctly used the =FREQUENCY() function if Excel automatically puts {} around the function.
Don't forget to push Control-Shift-Enter at the same time to enter the =FREQUENCY function.
Note: Some versions of Excel treat the last bin a bit differently, so the FREQUENCY function may show the last bin as one higher than it should be.
If you get that, don't worry about it, we will accept either answer.

Q5 - Charts
Copy the Bins and Frequency Data from the Q4 - Frequency sheet
16) Histogram
Create a Histogram of the Bins and Frequency data by first creating a column Chart and then removing the spaces between the columns.
Format the histogram so there are no spaces between the bars. Histograms do not have spaces and the graph does not become a Histogram until the spaces are removed.
Add a title to the Histogram
Add horizontal and Vertical Axes titles
17) Explain the difference between a histogram and a bar graph:
Give an example of when you will use a histogram or a bar chart
18) Make a pie chart of the raw frequency data with a title and Legend:
Give an example of when you will use a pie chart.

Purchase this Solution

Solution Summary

All tables, charts, computations and solutions are included in the Excel file attached.

Solution provided by:
  • MSc, California State Polytechnic University, Pomona
  • MBA, University of California, Riverside
  • BSc, California State Polytechnic University, Pomona
  • BSc, California State Polytechnic University, Pomona
Recent Feedback
  • "Excellent work. Well explained."
  • "Can you kindly take a look at 647530 and 647531. Thanks"
  • "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
  • "GREAT JOB!!!"
  • "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution

Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

Measures of Central Tendency

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

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.