DATA IDGenderAgeClassMajorGrad IntentionGPAEmploymentSalarySocial NetworkingSatisfactionSpendingComputerText MessagesWealth...

1 answer below »
please see the attached file and submit the answer in the same excel sheet.Answers should be in an Excel sheet.





DATA IDGenderAgeClassMajorGrad IntentionGPAEmploymentSalarySocial NetworkingSatisfactionSpendingComputerText MessagesWealth 1Female20SophomoreOtherYes2.88Full-Time55.053850Laptop2002.0A.Comparing data characteristics to therotical properties 2Male23SeniorManagementYes3.60Part-Time30.044860Desktop5010.0 3Male21FreshmanOtherYes2.50Part-Time50.0241100Laptop20070.0C. Writing a report summerizing your conclusion 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 Sheet1 6.9 Consumers spent an average of $15.30 on a meal at a restaurant in 2014. Assume that the amount spent on a restaurant meal is normally distributed and that the standard deviation is $2 a. What is the probability that a randomly selected person spent more than $16? c. Between what two values will the middle ninety-five percent of the amounts spent fall? Sheet2 Given the following probability distributions: DistributionADistribution B Xi p(x=xi) xi p(x=xi) 0 0.050 0.05 1 0.021 0.10 2 0.152 0.15 3 0.103 0.20 4 0.054 0.50 a. compute the expected valve for each distribution b. compute the standard deviation for each distribution. c. compute the results of distribution A and B 6.22 The file unity contains the electricity costs, in dollars, during July 2015 for a random sample of 50 one-bedroom apartments in a large city: 96 171 202a. comparing data chracteristics to theoretical properties 178 147 102 153 197 127 82 157 185 90 116 172 111 148 213 130 165 141 149 206 175 123 128 144 168 109 167 95 163 150 154 130 143 187 166 139 149 108 119 183 151 114 135 191 137 191 137 129 158
Answered Same DayMar 31, 2021

Answer To: DATA IDGenderAgeClassMajorGrad IntentionGPAEmploymentSalarySocial...

Pooja answered on Apr 01 2021
137 Votes
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        A.Comparing data characteristics to therotical properties
    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        C. Writing a report summerizing your...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here