Mathematics, 15.02.2021 20:30 keith1577621
1. In the file MajorSalary. xlsx, data have been collected from 111 College of Business graduates on their monthly starting salaries. The graduates include students majoring in management, finance, accounting, info systems, and marketing. Create a PivotTable in Excel to display the number of graduates in each major and the average monthly starting salary for students in each major.
a. Which major has the most graduates?
b. Which major has the highest average starting monthly salary?
c. Use the PivotTable to determine the major of the student with the lowest overall starting salary?
2. In the file Jensen. xlsx, Jensen auto is deciding whether to purchase a new maintenance contract for its new computer wheel alignment and balancing machine. The data in the file shows the relationship between usage and annual expense.
a. Develop a scatter chart with usage as the independent variable.
b. Use the data to develop a regression equation that could be used to predict the annual maintenance expense for a given numbers of hours of weekly usage. What is the model?
c. How much of the variation in the sample values of annual maintenance does the model you estimate in part b explain (Hint: Use r squared to explain).
Weekly Usage (hours)Annual Maintenance Expense
13 17.0
10 22.0
20 30.0
28 37.0
32 47.0
17 30.5
24 32.5
31 39.0
40 51.5
38 40.0
Answers: 1
Mathematics, 21.06.2019 17:00
Solve with work adding cheese to a mcdonalds quarter pounder increases the fat content from 21g to 30g. what is the percent of change ?
Answers: 2
Mathematics, 21.06.2019 20:00
Leslie started last week with $1200 in her checking account. during the week, she wrote the checks below.
Answers: 1
1. In the file MajorSalary. xlsx, data have been collected from 111 College of Business graduates on...
History, 11.12.2019 23:31
Chemistry, 11.12.2019 23:31
Mathematics, 11.12.2019 23:31
Mathematics, 11.12.2019 23:31
Arts, 11.12.2019 23:31
English, 11.12.2019 23:31
Social Studies, 11.12.2019 23:31
Mathematics, 11.12.2019 23:31
Mathematics, 11.12.2019 23:31