math108x_document_w05GroupAssignmentSummerSalesTextbox (1)

xlsx

School

Brigham Young University, Idaho *

*We aren’t endorsed by this school

Course

100B

Subject

Business

Date

Feb 20, 2024

Type

xlsx

Pages

12

Uploaded by HighnessHedgehogPerson363

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 Compan option fo because median, all the h more ba commisi dramatic numbers
ompany do you think ould work for? Why? ny B is the best or this problem, e the minimum, , and mode are highest, with alanced ions and less c variations in s.
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? League A. League A has the smaller standard deviation which means there is less of a variance of age, which is what it has to come down to since the mean age is the same for both leagues
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 in the 63rd Being in means t surpassi percent, perform for the s
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 be d percentile in this context. Is the 63rd percentile really a " grade"? Why or why not? the 63rd percentile that the school would be ing other schools by 63 , while 37 percent med higher than they did standardized testing. If this was an individual tes grade, the score would be categorized as a poor grad in this case, it is actually a score to be in this percenti because the school did bett the standardized testing th percent of schools.
"failing st de, but good tile, tter on han 63
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