08 Oct 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
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
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.
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 WriteEdu. 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 help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
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.
Chat with us today! We are always waiting to answer all your questions.