(a) State the null and alternative hypotheses. Ho: ▼ H₂: ▼ ▼ min (Type integers or decimals. Do not round.) (b) Determine the test statistic. to=(Round to two decimal places as needed.) (c) Determine a range for the P-value. The P-value is in the range ▼ min (d) The P-value for this hypothesis test using Student's t-distribution is 0.073. Interpret this result. We would expect a sample mean of minutes or less to occur in about [ of every 100 repetitions of this study. (Type integers or decimals. Round to one decimal place as needed.) (e) Write a conclusion based on the results. Use a = 0.05. the null hypothesis. There sufficient evidence to conclude the mean number of minutes studying is 480 minutes.

Please give the excel formula or spreadsheet.

Set A: n = 5; x = 10Set B: n = 50; x = 10(a) Suppose the number 32 is included as an additional data value in Set A. Compute x  for the new data set.  To compute x for the new data set, add 32 to x of the original data set and divide by 6. (Round your answer to two decimal places.) b.) Suppose the number 32 is included as an additional data value in Set B. Compute x for the new data set. (Round your answer to two decimal places.)

Number of ChildrenTable 1 shows the number of women (per 1000) between 15 and 50 years of age who have been married grouped by the number of children they have had. Table 2 gives the same information for women who have never been married.1 Number of Children     Women per 1000 0   162 1   213 2   344 3   182 4   69 5+      32 Table 1 Women who have been married Number of Children     Women per 1000 0   752 1   117 2   72 3   35 4   15 5+      10 Table 2 Women who have never been married 1http://www.census.gov/hhes/fertility/data/cps/2014.html, Table 1, June 2014.   Condition gt requires numbers instead of "null" and "0" (a) Without doing any calculations, which of the two samples appears to have the highest mean number of children?  Women who have been marriedWomen who have never been married Which of the distributions appears to have the mean most different from the median?  Women who have been marriedWomen who have never been married…

The table shows the leading causes of death in a certain country in a recent year. The population of the country was 311311 million. If you lived in a typical city of​ 500,000, how many people would you expect to die of cancercancer each​ year?             Cause Deaths   Cause Deaths   Heart disease 596 comma 700596,700   ​ Alzheimer's disease 84 comma 90084,900   Cancer 575 comma 300575,300   Diabetes 73 comma 40073,400   Chronic respiratory diseases 143 comma 100143,100   ​ Pneumonia/Influenza 53 comma 40053,400   Stroke 128 comma 600128,600   Kidney disease 45 comma 30045,300   Accidents 122 comma 500122,500   Suicide 38 comma 60038,600   About people would be expected to die of cancer each year. ​(Type a whole number. Round to the nearest person as​ needed.)

Weight City MPG 3968 20 3583 22 3470 22 3527 23 3990 18 4724 17 3692 21 3315 22 3616 20 5527 14 3719 16 3097 26 3800 19 3532 25 2269 31 5674 15 3402 20 4029 19 3996 19 3242 23 2434 31 2575 29 2960 27 3618 15 4054 19 3192 24 3305 23 3605 19 4240 15 3933 18 3633 19 3790 17 3477 20 3258 21 4685 17 2776 25 2615 24 3186 21 5137 13 3461 21 4233 16 4178 18 4702 17 3713 22 5794 14 2306 28 3194 26 3428 22 4894 12 4751 17 2605 29 3296 25 5267 13 2789 25 3570 19 4011 18 2363 27 4398 15 2806 25 2127 36 2665 27 3419 24 3427 24 3280 25 5765 13 3465 24 2295 30 3038 22 3070 25 4711 17 3230 24 3528 21 4667 16 SUMMARY OUTPUT                                   Regression Statistics               Multiple R 0.894328844               R Square 0.799824082               Adjusted R Square 0.797004703               Standard Error 2.238112689…

please help me solve this practice question using excel functions    7065 6870 6858 6641 6306 6671 6663 6492 6569 6601 6653 6729 7237 6911 6784 7312 7313 7082 7462 7311 6994 7399 7231 7666 7574 7706 7561 7198 7255 7116 7362 7511 7773 7776 7547 7567 7679 7627 7883 7274 7072 7165 7025 7125 7195 7318 7461 7624 7717 7450 7108 7053 6768 6896 7158 7152 7171 6902 6968 6619 6427 6567 6422 6686 6976 7069 7222 7381 7495 7460 7721 7804 7558 7781 7517 7795 7976 8038 8122 7854 7924 7754 7824 7935 8233 8304 8094 7974 7659 7538 7282 7435 7399 7712 8259 7935 8142 7696 7366 7182 7184 7408 7408 7805 7187 7074 7141 7245 7518 7748 7620 7434 7489 7345 7557 7490 7625 7691 7698 8019 8015 8064 8068 7839 7923 7939 8215 8730 8487 8444 8364 7893 8183…

The following data are stored in the variable called "data": 2 3 4 7 1 1 0 9 4 2 3 1 Write the MATLAB command that will set the variables equal to the indicated portion of data: 2347 Y =1109 MATLAB Command: Y = 4231 2347 X= 791 MATLAB Command: X = 7 3 Z= 9 1 MATLAB Command: Z = 1 2 4 S= 0 MATLAB Command: S = 3

Sex (1=Male 2=Female) 1 2 Total Ever told heart disease (1=Yes 2=No) 1 Count 73 96 169 % within Ever told heart 43.2% 56.8% 100.0% disease (1=Yes 2=No) % within Sex (1=Male 10.2% 9.3% 9.7% 2=Female) % of Total 4.2% 5.5% 9.7% 2 Count 640 941 1581 % within Ever told heart 40.5% 59.5% 100.0% disease (1=Yes 2=No) % within Sex (1=Male 89.8% 90.7% 90.3% 2=Female) % of Total 36.6% 53.8% 90.3% Total Count 713 1037 1750 % within Ever told heart disease (1=Yes 2=No) 40.7% 59.3% 100.0% % within Sex (1=Male 100.0% 100.0% 100.0% 2=Female) % of Total 40.7% 59.3% 100.0% What percent of the sample is male and has heart disease? 4.2% 40.5% 43.2% 10.2%