group week 5

xlsx

School

Brigham Young University *

*We aren’t endorsed by this school

Course

108X

Subject

Management

Date

Feb 20, 2024

Type

xlsx

Pages

12

Uploaded by ElderGalaxy13327

Report
Summarizing Data C Mean Median Mode Max Min Please refer t Ariel is a college student thinking of working for the summer selling products door-to-door. He needs help deciding which company to work for. To the right are the commission records for the employees of the companies Ariel is thinking of working for. You need to analyze the data by calculating the mean, median, mode, minimum, and maximum for each company. Then explain which company you think Ariel should work for, and why.
Company A Company B Company C $ 25,000 $ 5,600 $ 13,000 $ 28,300 $ 7,600 $ 14,100 $ 5,000 $ 5,800 $ 1,200 $ 2,200 $ 6,100 $ 1,600 $ 19,000 $ 6,000 $ 2,100 $ 2,600 $ 7,200 $ 13,300 $ 1,300 $ 8,900 $ 12,100 $ 8,600 $ 3,800 $ 11,900 $ 31,230 $ 5,000 $ 5,600 $ 3,400 $ 6,700 $ 1,800 $ 4,900 $ 5,200 $ 2,100 $ 17,000 $ 6,100 $ 4,500 $ 3,700 $ 6,300 $ 5,200 $ 1,800 $ 8,800 $ 16,800 $ 115,000 $ 3,600 $ 3,600 $ 300 $ 3,800 $ 4,300 $ 1,800 $ 4,100 $ 6,700 $ 15,948.82 Mean $ 5,917.65 Mean $ 7,052.94 $ 4,900.00 Median $ 6,000.00 Median $ 5,200.00 $ 1,800.00 Mode $ 6,100.00 Mode $ 2,100.00 $ 115,000.00 Max $ 8,900.00 Max $ 16,800.00 $ 300.00 Min $ 3,600.00 Min $ 1,200.00 to your textbook if you have any questions about how to use Excel to make these calculations. Which co Ariel sho ariel sho compan more co numbers income.
ompany do you think ould work for? Why? ould join ny b becuase it is onsitent in its s and a higher .
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Understanding Standard Deviation Players' Ages 18 19 19 21 20 18 19 20 21 21 19 20 21 21 20 20 21 21 19 20 21 21 18 19 20 Meet Thiago: Thiago is a coach trying to build a new soccer (futbol team. He would like his players to be around 20 years old. His team needs 20 players. League A Player Ages Thiago decides to scout two local soccer recreational leagues for players. -Both leagues have the same mean (average) age. -Thiago has not heard much else about either league before he visits the games.
21 21 20 20 21
19 21 25 18 17 28 18 19 18 22 21 18 16 18 19 19 17 21 23 22 17 18 22 25 22 League B Player Ages
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
25 19 19 18 16
League A Mean Age 20 League B Mean Age 20 League A Standard Deviation 1.02 League B Standard Deviation 2.99 Calculate the mean players age for each league. Calculate the Standard deviation for the ages of each league. Based on the standard deviation which league should Thiago scout? What additional information did the standard deviation give that the mean did not? legue A the variety in age is smaller in a than in b
Understanding Percentiles Overhead at a School Board Meeting: "Our school district average is in the 63rd percentile for the standardized test!! That is a failing grade!!! We must change the curriculum." Explain wh be in the 6 context. being in means b than oth percent
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
hat it means for a school to 63rd percentile in this Is the 63rd percentile really a " grade"? Why or why not? n the 63rd percentile being 63 percent higher hers but below 37 lower not neccessarily because i depends on what the othe school districs got on their and its baced on a percetil comparison.
"failing it er r test le of
Save this file and upload it to the W05 Group Assignment Submission folder in I-Learn. Then, as a group, answer the W05 Group Assignment Quiz. Also, discuss any homework problems that you are struggling with.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help