hypothesis testing assignment statistics homework

hypothesis testing assignment statistics homework hypothesis testing assignment statistics homework I don’t know how to handle this Statistics question and need guidance. 1) The first assignment is ”analysing college success scenario”. You have to choose only one role to to the task. 2) The second assignment is hypothesis testing assignment. You will see the direction what to do on the screenshots. I choose variable PCT_DIABETES_ADULTS10 I uploaded the excel file for reference. Do not use the actual mean calculated in the file for the state. Suppose that PCT_DIABETES_ADULTS10 equals to 10% and then make a claim and provide an alternative hypothesis. All the directions how to do the task you find on the screenshots. Let me know if you have any questions. screen_shot_2016_08_29_at_7.52.23_am.png screen_shot_2016_08_29_at_7.55.26_am.png __h217r2_analyzing_college_success_scenario.doc calculation_for_variables_in_selected_state.xlsx ORDER NOW FOR CUSTOMIZED AND ORIGINAL ESSAY PAPERS Microsoft Office User O f f i c e U s e r ?????( ? `K /MTH217r2_Analyzing_ Success 8? M i c r o s o f t County names Alameda Alpine Amador Butte Calaveras Colusa Contra Costa Del Norte El Dorado Fresno Glenn Humboldt Imperial Inyo Kern Kings Lake Lassen Los Angeles Madera Marin Mariposa Mendocino Merced Modoc Mono Monterey Napa Nevada Orange Placer Plumas Riverside Sacramento San Benito San Bernardino San Diego San Francisco San Joaquin San Luis Obispo Population 2010 1510271 1175 38091 220000 45578 21419 1049025 28610 181058 930450 28122 134623 174528 18546 839631 152982 64665 34895 9818605 150865 252409 18251 87841 255793 9686 14202 415057 136484 98764 3010232 348432 20007 2189641 1418788 55269 2035210 3095313 805235 685306 269637 PCH_FFRPTH_07_12 GROCPTH12 1.498950191 0.235412164 -49.33569531 0.885739593 -1.870602883 0.324017821 0.924169547 0.212152262 -3.040808454 0.290554736 -17.87710367 0.607164542 -4.740998582 0.180622955 -20.16209665 0.282785437 -18.20450911 0.188302014 -0.393026326 0.242642909 -28.11319107 0.214346956 -1.46671908 0.304093394 -7.558536971 0.192146845 0.177750743 0.216274669 -1.339183133 0.225425681 13.13226395 0.204804313 9.693065792 0.328212181 4.002020322 0.237684949 4.056683151 0.206167169 8.031698732 0.256211486 3.665879031 0.261648228 -36.15749791 0.50265289 -18.69811115 0.571899163 -0.377718686 0.221116639 13.82723991 0.643293664 -10.61471982 0.348480624 3.070485495 0.271814266 16.58727134 0.273292819 17.23532271 0.264517967 3.584222619 0.17604426 -5.728698479 0.174186164 -26.97239548 0.567039538 -0.904458386 0.153386199 -4.993738109 0.18894975 -28.13664651 0.175796357 0.976804867 0.163838884 0.347807433 0.195463546 13.72393912 0.420166541 -13.43984887 0.226298441 -10.07977406 0.26200492 San Mateo Santa Barbara Santa Clara Santa Cruz Shasta Sierra Siskiyou Solano Sonoma Stanislaus Sutter Tehama Trinity Tulare Tuolumne Ventura Yolo Yuba 718451 423895 1781642 262382 177223 3240 44900 413344 483878 514453 94737 63463 13786 442179 55365 823318 200849 72155 1.196550129 0.235354269 2.661916061 0.275942669 3.083206135 0.184489394 14.93015283 0.277386272 -12.3862419 0.201583551 -46.33830201 0 -3.299579997 0.452960094 -7.156114392 0.163990142 -12.63201235 0.276518871 1.600277813 0.268340087 -7.148607691 0.263096967 14.38156356 0.173485159 3.009019666 0.813248558 11.28614407 0.23673771 -12.52317277 0.20367353 -0.080417073 0.210531101 -2.904461837 0.191065952 12.36125858 0.150837836 -4.062574568 -0.648742356 #N/A 14.43931222 0.284067157 0.236074937 #N/A 0.160467868 -49.33569531 17.23532271 0 0.885739593 PCT_DIABETES_ADULTS10 RECFACPTH12 PCT_18YOUNGER10 PCT_HISP10 7.8 0.084259545 22.553634 22.505166 9.6 0 21.787234 7.148936 9.8 0.10800594 16.783492 12.485889 8.1 0.090277558 20.985455 14.143636 9.1 0.111751822 19.621309 10.318575 7.8 0.093409929 29.926701 55.109949 7.6 0.115783945 24.833059 24.361669 8.8 0.03534818 21.454037 17.801468 8.1 0.105227596 22.741332 12.081764 9 0.045363674 29.825031 50.305766 7.8 0.035724493 27.967428 37.475997 8.4 0.118670593 20.10132 9. 813331 7.4 0.045211022 29.277824 80.371631 9.3 0.108137334 21.028793 19.395018 7.8 0.046720348 30.261031 49.192205 7.5 0.059459317 27.812422 50.898799 10 0.062516606 21.142813 17.146834 7.5 0.118842474 18.034102 17.529732 7.7 0.075179751 24.465879 47.74496 9.1 0.059125728 28.402214 53.685083 5.5 0.238217043 20.686267 15.47845 9.4 0.111700642 17.76341 9.183058 7.7 0.171569749 22.154802 22.204893 8 0.057185338 31.548166 54.921362 8.8 0 21.928557 13.855049 6.6 0.069696125 20.975919 26.489227 6.9 0.049207755 26.746447 55.414798 7.2 0.122262577 23.069371 32.245538 7.2 0.183127823 19.345106 8.544611 7.4 0.102261004 24.471835 33.650994 7.2 0.135478127 24.419399 12.831772 9.3 0.103098098 17.9987 8.022192 9.5 0.057740207 28.320076 45.452976 9.2 0.084820508 25.588953 21.581519 7.4 0.070318543 29.068737 56.425845 8.5 0.049007526 29.215069 49.191238 7.5 0.097574395 23.395631 32.027391 6.9 0.134404859 13.353121 15.12279 9.5 0.048390862 29.28969 38.864536 6.7 0.120085588 18.85535 20.75865 0 22.238399 23.13002 24.109501 21.121113 22.374071 17.037037 20.768374 24.564285 22.003687 28.604751 27.562621 25.463656 18.279414 32.59404 17.487582 25.739143 22.719058 29.090153 25.40215 42.861322 26.897098 32.049455 8.395073 8.302469 10.278396 24.037122 24.888505 41.919864 28.764897 21.91198 6.956333 60.623639 10.689063 40.272046 30.347674 25.016977 8.077586207 7.8 7.8 1.07915547 0.085570375 0.087549033 0 0.046857009 23.65666588 22.9053515 #N/A 4.330811101 28.47236828 24.625087 #N/A 17.31280008 5.5 10.4 0 0.238217043 13.353121 32.59404 6.956333 80.371631 7.2 0.12849802 6.6 0.099710376 7.6 0.117550765 6 0.138693136 9 0.07279406 9.5 0 8.8 0.067944014 10.4 0.095066749 6.6 0.124026847 8.3 0.072835166 8.4 0.105238787 8.9 0 9.5 0.147863374 7.4 0.024337522 7.9 0.074063102 7.1 0.090911157 7 0.078386032 7.7 PCH_FFRPTH_07_12 -49.3356953 -46.338302 -36.1574979 -28.1366465 -28.1131911 -26.9723955 -20.1620967 -18.6981111 -18.2045091 -17.8771037 -13.4398489 -12.6320123 -12.5231728 -12.3862419 -10.6147198 -10.0797741 -7.55853697 -7.15611439 -7.14860769 -5.72869848 -4.99373811 -4.74099858 -3.29958 -3.04080845 -2.90446184 -1.87060288 -1.46671908 -1.33918313 -0.90445839 -0.39302633 -0.37771869 -0.08041707 0.177750743 0.347807433 0.924169547 0.976804867 1.196550129 1.498950191 1.600277813 2.661916061 Classes From -50 up to -40 From -40 up to -30 From -30 up to -20 From -20 up to -10 From -10 up to 0 From 0 up to 10 From 10 up to 20 3.009019666 3.070485495 3.083206135 3.584222619 3.665879031 4.002020322 4.056683151 8.031698732 9.693065792 11.28614407 12.36125858 13.13226395 13.72393912 13.82723991 14.38156356 14.93015283 16.58727134 17.23532271 Frequency 2 1 4 9 16 17 9 Fast-food restaurants/1,000 pop (% change), 2007-12 18 16 14 12 10 Frequency 8 6 hypothesis testing assignment statistics homework 4 2 0 From -50 up to – From -40 up to – From -30 up to – From -20 up to – From -10 up to From 0 up to 10 40 30 20 10 0 e), 2007-12 From 0 up to 10 From 10 up to 20 GROCPTH12 0 0.150837836 0.153386199 0.163838884 0.163990142 0.173485159 0.174186164 0.175796357 0.17604426 0.180622955 0.184489394 0.188302014 0.18894975 0.191065952 0.192146845 0.195463546 0.201583551 0.20367353 0.204804313 0.206167169 0.210531101 0.212152262 0.214346956 0.216274669 0.221116639 0.225425681 0.226298441 0.235354269 0.235412164 0.23673771 0.237684949 0.242642909 0.256211486 0.261648228 0.26200492 0.263096967 0.264517967 0.268340087 0.271814266 0.273292819 Classes Frequency 0 up to 0.1 1 0.1 up to 0.2 15 0.2 up to 0.3 29 0.3 up to 0.4 4 0.4 up to 0.5 2 0.5 up to 0.6 3 0.6 up to 0.7 2 0.7 up to 0.8 0 0.8 up to 0.9 2 0.275942669 0.276518871 0.277386272 0.282785437 0.290554736 0.304093394 0.324017821 0.328212181 0.348480624 0.420166541 0.452960094 0.50265289 0.567039538 0.571899163 0.607164542 0.643293664 0.813248558 0.885739593 Grocery stores per 1,000 pop, 2012 35 30 25 20 15 10 5 0 0 up to 0.1 0.1 up to 0.2 up to 0.3 up to 0.4 up to 0.5 up to 0.6 up to 0.7 up to 0.8 up to 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 PCT_DIABETES_ADULTS10 5.5 6 6.6 6.6 6.6 6.7 Classes 5 – 5.99 6 – 6.99 7 – 7.99 8 -hypothesis testing assignment statistics homework b8.99 9 – 9.99 10 – 10.99 Frequency 1 7 23 11 14 2 6.9 6.9 7 7.1 Adult diabet 7.2 7.2 25 7.2 7.2 7.4 7.4 20 7.4 7.4 7.5 7.5 15 7.5 7.6 7.6 10 7.7 7.7 7.7 7.8 5 7.8 7.8 7.8 7.9 8 8.1 8.1 8.3 8.4 8.4 8.5 8.8 8.8 0 5 – 5.99 6 – 6.99 8.8 8.9 9 9 9.1 9.1 9.2 9.3 9.3 9.4 9.5 9.5 9.5 9.5 9.6 9.8 10 10.4 Adult diabetes rate, 2010 6 – 6.99 7 – 7.99 8 – 8.99 9 – 9.99 10 – 10.99 RECFACPTH12 0 0 0 0 0 0.024337522 0.03534818 0.035724493 0.045211022 0.045363674 0.046720348 0.048390862 0.049007526 0.049207755 0.057185338 0.057740207 0.059125728 0.059459317 0.062516606 0.067944014 0.069696125 0.070318543 0.07279406 0.072835166 0.074063102 0.075179751 0.078386032 0.084259545 0.084820508 0.090277558 0.090911157 0.093409929 0.095066749 0.097574395 0.099710376 0.102261004 0.103098098 0.105227596 0.105238787 0.10800594 Classes Frequency 0 – 0.039 8 0.04 – 0.079 19 0.08 – 0.119 20 0.12 -0.159 8 0.16 hypothesis testing assignment statistics homework – 0.199 2 0.2 – 0.239 1 0.108137334 0.111700642 0.111751822 0.115783945 0.117550765 0.118670593 0.118842474 0.120085588 0.122262577 0.124026847 0.12849802 0.134404859 0.135478127 0.138693136 0.147863374 0.171569749 0.183127823 0.238217043 Recreation & fitness facilities/1,000 pop, 2012 25 20 15 10 5 0 0 – 0.039 0.04 – 0.079 0.08 – 0.119 0.12 -0.159 0.16 – 0.199 000 pop, 2012 0.16 – 0.199 0.2 – 0.239 PCT_18YOUNGER10 13.353121 16.783492 17.037037 17.487582 17.76341 17.9987 18.034102 18.279414 18.85535 19.345106 19.621309 20.10132 20.686267 20.768374 20.975919 20.985455 21.028793 21.121113 21.142813 21.454037 21.787234 21.928557 22.003687 22.154802 22.238399 22.374071 22.553634 22.719058 22.741332 23.069371 23.13002 23.395631 24.109501 24.419399 24.465879 24.471835 24.564285 24.833059 25.463656 25.588953 Classes 13 – 16.9 17 – 20.9 21 – 24.9 25 – 28.9 29 – 32.9 Frequency 2 12 24 10 10 25.739143 26.746447 27.562621 27.812422 27.967428 28.320076 28.402214 28.604751 29.068737 29.090153 29.215069 29.277824 29.28969 29.825031 29.926701 30.261031 31.548166 32.59404 % Population under age 18, 2010 30 25 20 15 10 5 0 13 – 16.9 17 – 20.9 21 – 24.9 25 – 28.9 29 – 32.9 29 – 32.9 PCT_HISP10 6.956333 7.148936 8.022192 8.302469 8.395073 8.544611 9.183058 9.813331 10.278396 10.318575 10.689063 12.081764 12.485889 12.831772 13.855049 14.143636 15.12279 15.47845 17.146834 17.529732 17.801468 19.395018 20.75865 21.581519 21.91198 22.204893 22.505166 24.037122 24.361669 24.888505 25.016977 25.40215 26.489227 26.897098 28.764897 30.347674 32.027391 32.049455 32.245538 33.650994 Classes Frequency 6 – 13.49 14 13.5 – 20.99 9 21 – 28.49 11 28.5 – 35.99 6 36 – 43.49 5 43.5 – 50.99 6 51 – 58.49 5 58.5 – 65.99 1 66 – 73.49 0 73.5 – 80.99 1 37.475997 38.864536 40.272046 41.919864 42.861322 45.452976 47.74496 49.191238 49.192205 50.305766 50.898799 53.685083 54.921362 55.109949 55.414798 56.425845 60.623639 80.371631 % Hispanic, 2010 16 14 12 10 8 6 4 2 0 6 – 13.49 13.5 – 21 – 28.49 28.5 – 36 – 43.49 43.5 – 51 – 58.49 58.5 – 66 – 73.49 20.99 35.99 50.99 65.99 66 – 73.49 73.5 80.99 … Purchase answer to see full attachment Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool’s honor code & terms of service . Get a 10 % discount on an order above $ 100 Use the following coupon code : NURSING10

RECOMMENDED: [Solved] Hypothesis Testing