Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In the Excel spreadsheet are the profits and losses in thousands for Princess Foods Corporation for 50 weeks. The data reflects the performance of the
In the Excel spreadsheet are the profits and losses in thousands for Princess Foods Corporation for 50 weeks. The data reflects the performance of the "Tiara" line during the period of the pilot.
Provide Bonnie with the following data in a short report:
- Determine the number of classes, the class range, and then construct a frequency table.
- Interpret information from the frequency table.
- Calculate the most appropriate measure and central tendency and explain why that
- measure was selected.
- Determine the percentile indicating the bottom ranking 20%. In other words, what is the
- dollar number that defines where the lowest values fall.
here is the data set that i put in order:
-2827 -2258 -1021 -795 -732 -617 -404 -387 -142 20 97 184 258 308 454 1417 1440 1578 1601 1939 2056 2080 2086 2294 2311 2403 2423 3006 3063 3154 3197 3273 3293 3368 3461 3484 3505 3535 3636 3640 3681 3709 3755 3780 3920 4567 4773 4942 5453 5600
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started