Create a PivotTable in MS Excel to display the number of graduates in each major and the average monthly starting salary for students in each major.

Assignment

WEBSITES
Q1 (20 pts). In a recent report, the top five most visited English-language websites were google.com (GOOG), facebook.com (FB), youtube.com (YT), yahoo.com (YAH), and Wikipedia.com (WIKI). The most-visited websites for a sample of 50 Internet users are shown in the following table:

YAH WIKI YT WIKI GOOG
YT YAH GOOG GOOG GOOG
WIKI GOOG YAH YAH YAH
YAH YT GOOG YT YAH
GOOG FB FB WIKI GOOG
GOOG GOOG FB FB WIKI
FB YAH YT YAH YAH
YT GOOG YAH FB FB
WIKI GOOG YAH WIKI WIKI
YAH YT GOOG GOOG WIKI

Conduct your analyses using the data file (WebSites.xlsx), and answer the following questions:
Are these data categorical or quantitative?
Provide frequency and percent frequency distributions.
On the basis of the sample, which website is most frequently the most-often-visited website for Internet users? Which is second?
COMMUTE TIME
Q2 (20 pts). The average time that Americans commute to work is 27.7 minutes (Sterling’s Best Places). The average commute times in minutes for 48 cities are as follows:

Albuquerque 23.3
Atlanta 28.3
Austin 24.6
Baltimore 32.1
Boston 31.7
Charlotte 25.8
Chicago 38.1
Cincinnati 24.9
Cleveland 26.8
Columbus 23.4
Dallas 28.5
Denver 28.1
Detroit 29.3
El Paso 24.4
Fresno 23.0
Indianapolis 24.8
Jacksonville 26.2
Kansas City 23.4
Las Vegas 28.4
Little Rock 20.1
Los Angeles 32.2
Louisville 21.4
Memphis 23.8
Miami 30.7
Milwaukee 24.8
Minneapolis 23.6
Nashville 25.3
New Orleans 31.7
New York 43.8
Oklahoma City 22.0
Orlando 27.1
Philadelphia 34.2
Phoenix 28.3
Pittsburgh 25.0
Portland 26.4
Providence 23.6
Richmond 23.4
Sacramento 25.8
Salt Lake City 20.2
San Antonio 26.1
San Diego 24.8
San Francisco 32.6
San Jose 28.5
Seattle 27.3
St. Louis 26.8
Tucson 24.0
Tulsa 20.1
Washington, D.C. 32.8

Conduct your analyses using the data file (CommuteTimes.xlsx), and answer the following questions:
What is the mean commute time for these 48 cities?
What is the median commute time for these 48 cities?
What is the mode for these 48 cities?
What is the variance and standard deviation of commute times for these 48 cities?
What is the third quartile of commute times for these 48 cities?

MAJOR SALARY
Q3 (20 pts). In the file MajorSalary, data have been collected from 111 College of Business graduates on their monthly starting salaries. The graduates include students majoring in management, finance, accounting, information systems, and marketing. Create a PivotTable in MS Excel to display the number of graduates in each major and the average monthly starting salary for students in each major.

Conduct your analyses using the data file (MajorSalary.xlsx), and answer the following questions:
Which major has the greatest number of graduates?
Which major has the highest average starting monthly salary?
Use the PivotTable to determine the major of the student with the highest overall starting monthly salary. What is the major of the student with the lowest overall starting monthly salary?

Create a PivotTable in MS Excel to display the number of graduates in each major and the average monthly starting salary for students in each major.
Scroll to top