Chat with us, powered by LiveChat Complete all the questions below, be sure to show your calculation/ paste your excel output. You can submit your file in wo | Wridemy

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

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

Related Tags

Academic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA


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