Sheet1 IDGenderAgeClassMajorGrad IntentionGPAEmploymentSalarySocial NetworkingSatisfactionSpendingComputerText MessagesWealth...

1 answer below »
please provide the answers in excel
Sheet1
IDGenderAgeClassMajorGrad IntentionGPAEmploymentSalarySocial NetworkingSatisfactionSpendingComputerText MessagesWealth
1Female20SophomoreOtherYes2.88Full-Time55.053850Laptop2002.0
2Male23SeniorManagementYes3.60Part-Time30.044860Desktop5010.0
3Male21FreshmanOtherYes2.50Part-Time50.0241100Laptop20070.0The student news service at Clear Mountain State University has decided to gather data about the undergraduate students who attend CMSU. They create and distribute a survey of 14 questions and receive responses from 111 under-graduates. For each numerical varriable included in the survey, compute all the appropriate descriptive statistics write a report summarizing your conclusions.
4Male21SophomoreISYes2.50Full-Time45.0461100Tablet250100.0
5Male23SeniorOtherUndecided2.80Unemployed45.0741000Laptop1001.0
6Female26SeniorEconomics/FinanceUndecided2.34Unemployed83.0321200Desktop05.0
7Female21JuniorOtherUndecided3.00Part-Time55.0331000Laptop500.6
8Female30SeniorOtherUndecided3.10Full-Time85.012700Tablet3001.0
9Female20SophomoreManagementYes3.60Unemployed35.0041000Laptop4000.6
10Female21SeniorEconomics/FinanceUndecided3.30Part-Time42.5114700Laptop1001.0
11Female23SeniorEconomics/FinanceYes2.80Full-Time55.055900Laptop20030.0
12Male22SeniorEconomics/FinanceNo3.50Full-Time42.0431000Laptop1004.0
13Male22SeniorMarketingUndecided3.40Part-Time45.063900Desktop450.7
14Male22SeniorMarketingUndecided3.10Part-Time45.013900Laptop1502.0
15Male21SeniorManagementYes3.20Part-Time59.0041100Laptop4006.0
16Male24SeniorManagementUndecided3.40Part-Time50.0441000Desktop1751.5
17Female19FreshmanISUndecided3.68Part-Time60.0104950Tablet1500.5
18Male21JuniorEconomics/FinanceUndecided3.10Part-Time60.0231100Laptop30010.0
19Male19SophomoreEconomics/FinanceYes3.50Part-Time57.0451000Laptop3002.0
20Female20SophomoreManagementUndecided3.17Unemployed65.0126800Laptop3500.4
21Female22JuniorMarketingUndecided3.19Part-Time60.01131190Laptop500.4
22Male18SophomoreAccountingUndecided2.95Unemployed65.0941100Laptop50010.0
23Female22SeniorMarketingUndecided3.00Part-Time60.004800Laptop350.2
24Male25SeniorUndecidedYes2.60Full-Time50.085900Laptop6001.5
25Female20JuniorEconomics/FinanceYes3.00Part-Time60.0731100Laptop3000.1
26Male24SeniorManagementYes3.30Full-Time65.001800Desktop4010.0
27Male23JuniorEconomics/FinanceYes3.10Full-Time70.045875Laptop3002.0
28Female20FreshmanMarketingYes2.90Part-Time55.01311400Laptop1001.0
29Male22SeniorMarketingYes3.33Part-Time60.0961600Laptop60100.0
30Male20SophomoreMarketingUndecided3.10Part-Time50.044900Laptop1407.0
31Male20SophomoreAccountingUndecided3.40Part-Time60.0431000Laptop5005.0
32Male20JuniorOtherYes2.90Part-Time52.031800Laptop3001.3
33Male20JuniorAccountingYes3.60Part-Time40.064700Laptop700.8
34Male22SeniorMarketingYes2.57Full-Time45.0541550Laptop8000.9
35Female19SophomoreMarketingUndecided3.40Part-Time45.0451000Laptop3000.1
36Female26JuniorAccountingYes3.30Part-Time65.024950Desktop3000.8
37Male21SeniorManagementYes3.05Part-Time45.0341000Laptop1005.0
38Female21SophomoreAccountingYes2.50Part-Time65.0231000Laptop6000.9
39Male24JuniorEconomics/FinanceYes2.75Part-Time55.0761100Desktop501.0
40Male19FreshmanMarketingYes2.50Unemployed55.0155800Laptop1001.0
41Male22JuniorAccountingYes3.20Full-Time65.0441180Desktop2000.5
42Female20JuniorMarketingNo3.30Part-Time35.0641100Laptop3501.0
43Female22SeniorMarketingUndecided3.50Unemployed45.055800Laptop506.0
44Female27SeniorMarketingNo3.90Full-Time35.045600Laptop4001.0
45Female21SeniorMarketingNo3.00Part-Time35.0651150Desktop5000.5
46Female21SeniorManagementUndecided3.82Part-Time65.0141150Laptop1501.0
47Female20JuniorMarketingYes3.50Unemployed65.053850Laptop2000.3
48Male19SophomoreUndecidedUndecided2.50Part-Time85.0341000Desktop1503.0
49Female21SeniorEconomics/FinanceYes3.20Part-Time52.524720Laptop1051.0
50Female23SophomoreEconomics/FinanceUndecided3.00Part-Time50.0531020Laptop1050.7
51Female21JuniorManagementNo3.50Unemployed40.0141100Tablet1001.0
52Male23SeniorManagementNo3.00Part-Time55.0441000Laptop2005.0
53Female21SeniorMarketingUndecided3.70Part-Time45.034800Laptop70010.0
54Male21JuniorMarketingNo3.40Part-Time45.0751000Laptop3000.5
55Male21SeniorOtherYes3.40Part-Time55.034750Desktop7002.5
56Female21SeniorMarketingNo3.10Part-Time55.031800Desktop3003.5
57Female21SeniorMarketingYes3.40Part-Time47.061700Laptop1003.8
58Female21SeniorMarketingNo2.40Part-Time45.0431500Laptop101.0
59Female20JuniorISNo2.90Part-Time45.044850Laptop2500.1
60Female20SophomoreISNo2.50Part-Time60.0741000Tablet5001.0
61Female23SeniorAccountingYes3.50Part-Time35.063990Laptop501.0
62Female23SeniorEconomics/FinanceNo3.20Part-Time75.023750Laptop02.0
63Male24JuniorEconomics/FinanceYes2.70Full-Time70.066570Tablet1001.0
64Male23JuniorEconomics/FinanceNo3.10Part-Time65.094650Laptop20010.0
65Male18FreshmanUndecidedYes3.60Unemployed55.0124700Tablet5001.0
66Male24SeniorManagementNo3.10Part-Time50.044800Laptop00.9
67Male23SophomoreMarketingNo2.20Unemployed50.054650Desktop10010.0
68Female22SeniorAccountingNo3.20Part-Time60.045800Laptop1001.0
69Female25SeniorMarketingYes2.80Full-Time50.032800Laptop07.5
70Male26SeniorEconomics/FinanceYes3.70Part-Time65.063800Desktop601.0
71Male19FreshmanEconomics/FinanceUndecided2.60Unemployed60.095800Laptop4000.1
72Female24SeniorManagementNo3.10Part-Time55.0441060Desktop6001.0
73Female20FreshmanAccountingUndecided2.40Part-Time60.085800Laptop51.0
74Male23JuniorISUndecided3.60Part-Time70.0126900Laptop101.0
75Male23SeniorManagementNo3.10Part-Time55.056800Laptop010.0
76Female28SeniorEconomics/FinanceYes3.50Part-Time75.046900Desktop3505.0
77Male25SeniorManagementNo2.50Full-Time50.023800Laptop50.5
78Male24SeniorEconomics/FinanceUndecided3.40Part-Time60.0351175Laptop6050.0
79Female21SophomoreUndecidedYes3.30Part-Time55.064900Laptop6501.0
80Female22SophomoreMarketingUndecided3.00Part-Time50.0551000Laptop2001.5
81Female19FreshmanUndecidedUndecided2.80Unemployed50.084850Tablet6502.0
82Male23JuniorEconomics/FinanceYes3.60Part-Time65.055680Laptop4005.0
83Male21JuniorManagementNo3.00Part-Time45.046700Laptop2010.0
84Male24SeniorISUndecided3.30Part-Time60.085750Laptop510.0
85Male22JuniorEconomics/FinanceYes3.70Part-Time65.063745Laptop2506.0
86Female21SophomoreManagementUndecided2.80Part-Time45.074715Laptop20010.0
87Male25SeniorAccountingYes3.40Part-Time55.024850Desktop60100.0
88Female20SophomoreMarketingUndecided3.10Unemployed50.034575Laptop4002.0
89Female22JuniorMarketingUndecided2.90Part-Time50.0642000Laptop25.0
90Female23SophomoreEconomics/FinanceYes3.50Part-Time60.045750Laptop5001.0
91Male27JuniorMarketingUndecided3.30Full-Time55.045800Laptop7510.0
92Male22JuniorManagementUndecided2.90Part-Time50.044670Laptop500.1
93Female26SeniorEconomics/FinanceYes3.60Part-Time65.035700Desktop1005.0
94Female30SeniorAccountingYes3.80Full-Time65.035800Desktop302.0
95Female22SophomoreAccountingNo2.10Unemployed60.094730Laptop5050.0
96Male19FreshmanEconomics/FinanceNo2.80Part-Time55.074650Laptop01.0
97Male24JuniorAccountingUndecided3.00Full-Time60.0541700Laptop3001.0
98Female20SophomoreEconomics/FinanceNo3.10Part-Time60.065800Laptop15.0
99Male19FreshmanEconomics/FinanceYes3.80Unemployed65.075900Laptop753.0
100Male24SeniorOtherNo3.10Part-Time50.037900Desktop10020.0
101Female22JuniorManagementYes3.20Part-Time50.046860Laptop753.0
102Male20FreshmanMarketingNo2.70Part-Time45.075640Laptop2105.0
103Male21SophomoreMarketingNo2.90Part-Time40.0551100Tablet4002.5
104Male23JuniorOtherNo3.00Part-Time45.065800Laptop21010.0
105Female24SeniorOtherNo3.20Part-Time45.084690Laptop5250.8
106Female18FreshmanManagementNo2.00Unemployed45.054750Laptop100100.0
107Male26SeniorEconomics/FinanceNo2.90Full-Time55.044850Laptop10050.0
108Female19FreshmanUndecidedUndecided3.30Unemployed50.073800Tablet75020.0
109Female21SophomoreUndecidedUndecided2.60Part-Time45.054800Laptop50050.0
110Male18FreshmanAccountingUndecided3.60Part-Time65.085900Laptop750100.0
111Female21SophomoreAccountingNo3.40Part-Time65.055950Tablet20075.0
Sheet2
DaysOne of the major measures of the quality of service provided by an organization is the speed with which it responds to customer complaints. A large family-held department store selling furniture and flooring, including carpet, had undergone a major expansion in the past several years. In particular, the flooring department had expanded from 2 installation crews to an installation supervisor, a measurer, and 15 installation crews. The busines objective of the company was to reduce the time between when a complaint is recieved and when it is resolved. During a recent year, the company received 5 complaints concerning carpet installation. The data from the 50 complaints, organized in Furniture, represent the number of days between the receipt of a complaint and the resolution of the complaint and the resolution of the complaaint
54a. Compute the mean, median, first quartile, and third quartile
5b. Compute the range, interquartile range, variance, standard deviation, and coefficient of variation
35c. Construct a boxplot. Are the data skewed? If so, how?
137d. On the basis of the results of (a) through ©, if you had to tell the president of the company how long a customer should expect to wait to have a complaint resolved, what would you say? Explain.
31
27
152
2
123
81
74
27
11
19
126
110
110
29
61
35
94
31
26
5
12
4
165
32
29
28
29
26
25
1
14
13
13
10
5
27
4
52
30
22
36
26
20
23
33
68
Sheet3
One-YearFive-Year
1.041.98The file CD Rate contains the yields for one-year CDs and five year CDs, for 5 banks in the United States, as of April 15, 2015.
1.091.73
0.551.34Source: Data extracted from www.Bankrate.com, Aprile 15, 2015
0.802.22For each tyoe of account:
1.301.85a. Compute the first quartile, the third quartile, and the interquartile range
1.341.49b. List the five-number summary
0.952.08c. Construct a boxplox and describe its shape.
0.901.45
0.851.50
0.751.83
0.401.49
1.002.10
0.401.39
1.001.60
0.951.20
1.192.13
0.230.93
0.701.75
0.590.49
1.001.60
0.801.98
1.222.23
0.651.75
0.711.05
1.151.80
Sheet4
One-YearFive-Year
1.041.98
1.091.73
0.551.34
0.802.223.15 Is there a difference in the variation of the yields of different types of investments? The file CD Rate contains the yields for one-year certtificates of deposit and five-year CDs for 25 banks in the United States, as of April 15, 2015
1.301.85
1.341.49a. For one-year and five-year CDs, separately computte the variance, standard deviation, range, and coefficient of variation.
0.952.08b. Based on the results of (a), do one-year CDs or five year CDs have more variation in the yields offered? Explain.
0.901.45
0.851.50
0.751.83
0.401.49
1.002.10
0.401.39
1.001.60
0.951.20
1.192.13
0.230.93
0.701.75
0.590.49
1.001.60
0.801.98
1.222.23
0.651.75
0.711.05
1.151.80
Answered Same DayMar 25, 2021

Answer To: Sheet1 IDGenderAgeClassMajorGrad IntentionGPAEmploymentSalarySocial...

Sudharsan.J answered on Mar 26 2021
91 Votes
Sheet1
    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    5    3    850    Laptop    200    2
    2    Male    23    Senior    Management    Yes    3.6    Part-Time    30    4    4    860    Desktop    50    10
    3    Male    21    Freshman    Other    Yes    2.5    Part-Time    50    2    4    1100    Laptop    200    70    The student news service at Clear Mountain State University has decided
to gather data about the undergraduate students who attend CMSU. They create and distribute a survey of 14 questions and receive responses from 111 under-graduates. For each numerical va
iable included in the survey, compute all the appropriate descriptive statistics write a report summarizing your conclusions.
    4    Male    21    Sophomore    IS    Yes    2.5    Full-Time    45    4    6    1100    Tablet    250    100
    5    Male    23    Senior    Other    Undecided    2.8    Unemployed    45    7    4    1000    Laptop    100    1
    6    Female    26    Senior    Economics/Finance    Undecided    2.34    Unemployed    83    3    2    1200    Desktop    0    5             Age    GPA    Salary    Social Networking    Satisfaction    Spending    Text Messages    Wealth            Gender    Frequency    Percentage
    7    Female    21    Junior    Other    Undecided    3    Part-Time    55    3    3    1000    Laptop    50    0.6        Mean    21.97    3.11    54.55    5.14    4.1    917.52    224.44    10.92            Female    55    49.55%            Grad Intention    Frequency    Percentage
    8    Female    30    Senior    Other    Undecided    3.1    Full-Time    85    1    2    700    Tablet    300    1        Standard E
or    0.23    0.04    1    0.27    0.11    21.89    19.48    2.23            Male    56    50.45%            No    31    27.93%
    9    Female    20    Sophomore    Management    Yes    3.6    Unemployed    35    0    4    1000    Laptop    400    0.6        Median    22    3.1    55    5    4    860    150    2                                Undecided    38    34.23%
    10    Female    21    Senior    Economics/Finance    Undecided    3.3    Part-Time    42.5    11    4    700    Laptop    100    1        Mode    21    3.1    45    4    4    800    100    1                                Yes    42    37.84%
    11    Female    23    Senior    Economics/Finance    Yes    2.8    Full-Time    55    5    5    900    Laptop    200    30        Standard Deviation    2.4    0.4    10.54    2.87    1.18    230.67    205.21    23.53            Class    Frequency    Percentage
    12    Male    22    Senior    Economics/Finance    No    3.5    Full-Time    42    4    3    1000    Laptop    100    4        Sample Variance    5.77    0.16    111.01    8.26    1.38    53209.49    42110.87    553.81            Freshman    14    12.61%
    13    Male    22    Senior    Marketing    Undecided    3.4    Part-Time    45    6    3    900    Desktop    45    0.7        Kurtosis    1.18    -0.21    0.47    1.08    0.78    5.16    0.17    8            Junior    27    24.32%            Employment    Frequency    Percentage
    14    Male    22    Senior    Marketing    Undecided    3.1    Part-Time    45    1    3    900    Laptop    150    2        Skewness    0.93    -0.41    0.37    0.86    -0.5    1.82    1.01    2.97            Senior    46    41.44%            Full-Time    18    16.22%
    15    Male    21    Senior    Management    Yes    3.2    Part-Time    59    0    4    1100    Laptop    400    6        Range    12    1.9    55    15    6    1430    800    99.9            Sophomore    24    21.62%            Part-Time    75    67.57%
    16    Male    24    Senior    Management    Undecided    3.4    Part-Time    50    4    4    1000    Desktop    175    1.5        Minimum    18    2    30    0    1    570    0    0.1                                Unemployed    18    16.22%
    17    Female    19    Freshman    IS    Undecided    3.68    Part-Time    60    10    4    950    Tablet    150    0.5        Maximum    30    3.9    85    15    7    2000    800    100
    18    Male    21    Junior    Economics/Finance    Undecided    3.1    Part-Time    60    2    3    1100    Laptop    300    10        Sum    2439    345.13    6055    570    455    101845    24913    1211.6
    19    Male    19    Sophomore    Economics/Finance    Yes    3.5    Part-Time    57    4    5    1000    Laptop    300    2        Count    111    111    111    111    111    111    111    111            Computer    Frequency    Percentage
    20    Female    20    Sophomore    Management    Undecided    3.17    Unemployed    65    12    6    800    Laptop    350    0.4        Confidence Level (95.0%)    0.45    0.08    1.98    0.54    0.22    43.39    38.6    4.43            Desktop    20    18.02%
    21    Female    22    Junior    Marketing    Undecided    3.19    Part-Time    60    11    3    1190    Laptop    50    0.4                                                    Laptop    80    72.07%
    22    Male    18    Sophomore    Accounting    Undecided    2.95    Unemployed    65    9    4    1100    Laptop    500    10                                                    Tablet    11    9.91%
    23    Female    22    Senior    Marketing    Undecided    3    Part-Time    60    0    4    800    Laptop    35    0.2        The Average age of 111-undergraduate student is 21.97. Maximum age was found to be 30 and minimum age is 18. It is noted that most of the people obtained GPA Score of 3.1. There was no much variation found in satisfaction, most of the students gave satisfaction score of 4. the average spending of the students is 917.52 , there was huge variation found in the data for both spendings and Text messages. Nearly equal ration were considered in gender, with female 55 and male 55. Overall 67.57% of the students work as a part-timer, remaining 16.22% were full timers. And it is noted that 72% of the under-graduate students have their own Laptop when compared Desktop which is just 18% and tablet...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here