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?
Below is the link the professor explains all three assignments need to completed in excel and also create a video presentation.
