Answered step by step
Verified Expert Solution
Link Copied!

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:

  1. Determine the number of classes, the class range, and then construct a frequency table.
  2. Interpret information from the frequency table.
  3. Calculate the most appropriate measure and central tendency and explain why that
  4. measure was selected.
  5. Determine the percentile indicating the bottom ranking 20%. In other words, what is the
  6. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra A Modern Introduction

Authors: David Poole

4th edition

1285463242, 978-1285982830, 1285982835, 978-1285463247

More Books

Students also viewed these Mathematics questions