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

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018

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