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).

Major salary excel document with all info needed!

Major	Monthy Salary
Management	3330
Management	2700
Finance	3155
Accounting	3855
Info Systems	4220
Accounting	3110
Accounting	3880
Management	3695
Finance	3775
Finance	3875
Accounting	4560
Accounting	3475
Marketing	2780
Marketing	3715
Marketing	3260
Management	3175
Finance	3355
Accounting	4205
Finance	4000
Finance	4245
Finance	2950
Marketing	3270
Management	3835
Accounting	4150
Marketing	3200
Accounting	3140
Finance	3700
Marketing	3480
Accounting	3760
Marketing	3440
Marketing	3535
Management	2630
Accounting	4280
Management	4285
Accounting	3240
Marketing	3115
Marketing	3645
Accounting	3800
Marketing	3635
Accounting	4890
Info Systems	3855
Marketing	3110
Finance	2955
Management	3440
Marketing	3935
Info Systems	4360
Info Systems	4285
Marketing	2495
Management	2800
Marketing	4485
Management	2840
Management	3135
Marketing	3190
Marketing	3190
Management	2240
Accounting	3780
Management	2975
Management	3275
Marketing	3645
Management	3250
Finance	3875
Marketing	2900
Management	2685
Accounting	3020
Info Systems	4410
Finance	3350
Accounting	5000
Accounting	4040
Accounting	3770
Accounting	4995
Info Systems	5030
Finance	3370
Accounting	4340
Accounting	4225
Finance	3400
Management	2890
Finance	4075
Finance	3530
Info Systems	3325
Marketing	3025
Marketing	4010
Management	2865
Management	4245
Accounting	5650
Accounting	4090
Info Systems	3715
Accounting	3800
Management	3365
Accounting	3095
Info Systems	3765
Info Systems	3860
Accounting	2700
Finance	5000
Info Systems	4610
Accounting	5500
Info Systems	3610
Info Systems	3865
Accounting	4210
Management	3190
Finance	3810
Finance	4175
Finance	3535
Management	2780
Info Systems	3965
Finance	3665
Info Systems	4295
Management	3080
Management	3615
Finance	3800
Info Systems	2830
Marketing	2530

Jensen excel document with all info needed!

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