Complete all the questions below, be sure to show your calculation/ paste your excel output. You can submit your file in wo
Complete all the questions below, be sure to show your calculation/ paste your excel output. You can submit your file in word or pdf format. Submit the Excel workbook as well.
Upload Speed
| Upload Speed |
| 0.854 |
| 1.023 |
| 1.005 |
| 1.030 |
| 1.219 |
| 0.977 |
| 1.044 |
| 0.778 |
| 1.122 |
| 1.114 |
| 1.091 |
| 1.086 |
| 1.141 |
| 0.931 |
| 0.723 |
| 0.934 |
| 1.060 |
| 1.047 |
| 0.800 |
| 0.889 |
| 1.012 |
| 0.695 |
| 0.869 |
| 0.734 |
| 1.131 |
| 0.993 |
| 0.762 |
| 0.814 |
| 1.108 |
| 0.805 |
| 1.223 |
| 1.024 |
| 0.884 |
| 0.799 |
| 0.870 |
| 0.898 |
| 0.621 |
| 0.818 |
| 1.113 |
| 1.286 |
| 1.052 |
| 0.678 |
| 1.162 |
| 0.808 |
| 1.012 |
| 0.859 |
| 0.951 |
| 1.112 |
| 1.003 |
| 0.972 |
Table AMS 1
| Continue subscriptions after trial periods | Discount Plans | ||||
| No Discount | Moderate Discount | Substantial Discount | Restaurant Card | Total | |
| Yes | 24 | 30 | 38 | 51 | 143 |
| No | 76 | 70 | 62 | 49 | 257 |
| Total | 100 | 100 | 100 | 100 | 400 |
,
A1: Individual Assignment – 60% of total grade
Complete all the questions below, be sure to show your calculation/ paste your excel output. You can submit your file in a word or pdf format, and be sure to submit your excel workbook as well.
Q1. In a recent academic year, many public universities in the United States raised tuition and
fees due to a decrease in state subsidies. The change in the cost of tuition, a shared dormitory
room, and the most popular meal plan from the previous academic year for a sample of 10 public
universities were as follows: $1,589, $593, $1,223, $869, $423, $1,720, $708, $1,425, $922 and
$308. Calculate the following statistics (paste the excel output) A. Mean
B. Median
C. Standard deviation of change in cost
D. Coefficient of Variation of Change in Cost
E. Skewness
Q2. A sample of eight analysts at a software firm were asked to estimate the reuse rate when
developing a new software system. The following data are given as a percentage of the total code
written for a software system that is part of the reuse database.
50, 62.5, 37.5, 75.0, 45.0, 47.5, 15.0, 25.0. Calculate the following statistics (paste the excel
output)
A. Mean percentage of the total code that is part of the reuse database
B. Variance of the total code that is part of the reuse database
C. Standard Deviation of the total code that is part of the reuse database
D. Skewness of the total code that is part of the reuse database
E. Coefficient of Variation of the total code that is part of the reuse database
Q3. Use Dataset AMS9.
The AMS technical services department has embarked on a quality improvement effort. Its first
project relates to maintaining target upload speed for its internet service subscribers. Upload
speeds are measured on a standard scale. Data collected over the past year indicate the upload
speed is approximately normally distributed. The technical operations department wants to
ensure that the mean target upload speed for all internet subscribers is at least 0.97 on a standard
scale in which the target value is 1.0. Each day, upload speed was measured 50 times,
Compute the sample statistics and determine whether there is evidence that the population mean
upload speed is less than 0.97. Summarize your conclusions from management (i.e., provide
managerial insights).
Q4. Use Dataset-StudentSurvey. You are hired as data analyst to provide recommendations to
the University administration of Clear Mountain State University (CMSU). You have asked the
student news service at Clear Mountain State University (CMSU) to gather data about the
Undergraduate students that attend CMSU. It creates and distributes a survey of 14 questions and
receives responses from 111 undergraduates, which it stores in StudentSurvey,
Student satisfaction (with the University) was a variable measured in the survey using a 7-point
Likert Scale (1= Not satisfied, 3=neutral, 4=satisfied, 7=extremely satisfied). At .05 level of
significance, is there evidence that the population student satisfaction mean is greater than 4?
Provide recommendations to the University administration which summarizes your conclusion
regarding student satisfaction.
,
DATA
| ID | Gender | Age | Class | Major | Grad Intention | GPA | Employment | Salary | Social Networking | Satisfaction | Spending | Computer | Text Messages | Wealth |
| 1 | Female | 20 | Sophomore | Other | Yes | 2.88 | Full-Time | 55.0 | 5 | 3 | 850 | Laptop | 200 | 2.0 |
| 2 | Male | 23 | Senior | Management | Yes | 3.60 | Part-Time | 30.0 | 4 | 4 | 860 | Desktop | 50 | 10.0 |
| 3 | Male | 21 | Freshman | Other | Yes | 2.50 | Part-Time | 50.0 | 2 | 4 | 1100 | Laptop | 200 | 70.0 |
| 4 | Male | 21 | Sophomore | IS | Yes | 2.50 | Full-Time | 45.0 | 4 | 6 | 1100 | Tablet | 250 | 100.0 |
| 5 | Male | 23 | Senior | Other | Undecided | 2.80 | Unemployed | 45.0 | 7 | 4 | 1000 | Laptop | 100 | 1.0 |
| 6 | Female | 26 | Senior | Economics/Finance | Undecided | 2.34 | Unemployed | 83.0 | 3 | 2 | 1200 | Desktop | 0 | 5.0 |
| 7 | Female | 21 | Junior | Other | Undecided | 3.00 | Part-Time | 55.0 | 3 | 3 | 1000 | Laptop | 50 | 0.6 |
| 8 | Female | 30 | Senior | Other | Undecided | 3.10 | Full-Time | 85.0 | 1 | 2 | 700 | Tablet | 300 | 1.0 |
| 9 | Female | 20 | Sophomore | Management | Yes | 3.60 | Unemployed | 35.0 | 0 | 4 | 1000 | Laptop | 400 | 0.6 |
| 10 | Female | 21 | Senior | Economics/Finance | Undecided | 3.30 | Part-Time | 42.5 | 11 | 4 | 700 | Laptop | 100 | 1.0 |
| 11 | Female | 23 | Senior | Economics/Finance | Yes | 2.80 | Full-Time | 55.0 | 5 | 5 | 900 | Laptop | 200 | 30.0 |
| 12 | Male | 22 | Senior | Economics/Finance | No | 3.50 | Full-Time | 42.0 | 4 | 3 | 1000 | Laptop | 100 | 4.0 |
| 13 | Male | 22 | Senior | Marketing | Undecided | 3.40 | Part-Time | 45.0 | 6 | 3 | 900 | Desktop | 45 | 0.7 |
| 14 | Male | 22 | Senior | Marketing | Undecided | 3.10 | Part-Time | 45.0 | 1 | 3 | 900 | Laptop | 150 | 2.0 |
| 15 | Male | 21 | Senior | Management | Yes | 3.20 | Part-Time | 59.0 | 0 | 4 | 1100 | Laptop | 400 | 6.0 |
| 16 | Male | 24 | Senior | Management | Undecided | 3.40 | Part-Time | 50.0 | 4 | 4 | 1000 | Desktop | 175 | 1.5 |
| 17 | Female | 19 | Freshman | IS | Undecided | 3.68 | Part-Time | 60.0 | 10 | 4 | 950 | Tablet | 150 | 0.5 |
| 18 | Male | 21 | Junior | Economics/Finance | Undecided | 3.10 | Part-Time | 60.0 | 2 | 3 | 1100 | Laptop | 300 | 10.0 |
| 19 | Male | 19 | Sophomore | Economics/Finance | Yes | 3.50 | Part-Time | 57.0 | 4 | 5 | 1000 | Laptop | 300 | 2.0 |
| 20 | Female | 20 | Sophomore | Management | Undecided | 3.17 | Unemployed | 65.0 | 12 | 6 | 800 | Laptop | 350 | 0.4 |
| 21 | Female | 22 | Junior | Marketing | Undecided | 3.19 | Part-Time | 60.0 | 11 | 3 | 1190 | Laptop | 50 | 0.4 |
| 22 | Male | 18 | Sophomore | Accounting | Undecided | 2.95 | Unemployed | 65.0 | 9 | 4 | 1100 | Laptop | 500 | 10.0 |
| 23 | Female | 22 | Senior | Marketing | Undecided | 3.00 | Part-Time | 60.0 | 0 | 4 | 800 | Laptop | 35 | 0.2 |
| 24 | Male | 25 | Senior | Undecided | Yes | 2.60 | Full-Time | 50.0 | 8 | 5 | 900 | Laptop | 600 | 1.5 |
| 25 | Female | 20 | Junior | Economics/Finance | Yes | 3.00 | Part-Time | 60.0 | 7 | 3 | 1100 | Laptop | 300 | 0.1 |
| 26 | Male | 24 | Senior | Management | Yes | 3.30 | Full-Time | 65.0 | 0 | 1 | 800 | Desktop | 40 | 10.0 |
| 27 | Male | 23 | Junior | Economics/Finance | Yes | 3.10 | Full-Time | 70.0 | 4 | 5 | 875 | Laptop | 300 | 2.0 |
| 28 | Female | 20 | Freshman | Marketing | Yes | 2.90 | Part-Time | 55.0 | 13 | 1 | 1400 | Laptop | 100 | 1.0 |
| 29 | Male | 22 | Senior | Marketing | Yes | 3.33 | Part-Time | 60.0 | 9 | 6 | 1600 | Laptop | 60 | 100.0 |
| 30 | Male | 20 | Sophomore | Marketing | Undecided | 3.10 | Part-Time | 50.0 | 4 | 4 | 900 | Laptop | 140 | 7.0 |
| 31 | Male | 20 | Sophomore | Accounting | Undecided | 3.40 | Part-Time | 60.0 | 4 | 3 | 1000 | Laptop | 500 | 5.0 |
| 32 | Male | 20 | Junior | Other | Yes | 2.90 | Part-Time | 52.0 | 3 | 1 | 800 | Laptop | 300 | 1.3 |
| 33 | Male | 20 | Junior | Accounting | Yes | 3.60 | Part-Time | 40.0 |
