# 3: Using Excel: A primary care provider is checking a patient glucose level over the past 9 weeks and found the following glucose readings (in mg/dl). 19 88 82 90 115 91 18 124 100 Let x be a random variable representing glucose reading taken from the patient. We may assume has a normal distribution, and we know from experience that = 10.5. The mean glucose level for horses should be #= 95 mg/dl. Do these data indicate that the patient has an overall average glucose level higher than 95? Use a =0.05. Please use excel and attach the screen shot of the full hypothesis test with step by step work.

Patients with two kinds of diagnoses were randomly assigned to one of three types of therapy and the effectiveness of the therapy was measured on a 1-to-15 scale (with a higher number indicating greater effectiveness). There were two patients per cell. Use the data available below to complete parts through (d) below. Click the icon to view the data table. Click here to view page 1 of the table of cutoff values for the F distribution. Click here to view page 2 of the table of cutoff values for the F distribution. Click here to view page 3 of the table of cutoff values for the F distribution. Click here to view page 4 of the table of cutoff values for the F distribution. (a) Carry out the analysis of variance (use the 0.05 significance level). Complete the analysis of variance table for the data set below. SS MS Source Columns Rows Interaction Within Total (Round to two decimal places as needed.) df F Data Table Diagnosis Diagnosis II Therapy A 5 1 11 7 Print Therapy B 7 5 12 Done…

Need help with this one in part D.

Patients with two kinds of diagnoses were randomly assigned to one of three types of therapy and the effectiveness of the therapy was measure a 1-to-15 scale (with a higher number indicating greater effectiveness). There were two patients per cell. Use the data available below to comple parts (a) through (d) below. Click the icon to view the data table. Click here to view page 1 of the table of cutoff values for the F distribution. Click here to view page 2 of the table of cutoff values for the F distribution. Click here to view page 3 of the table of cutoff values for the F distribution. Click here to view page 4 of the table of cutoff values for the F distribution (a) Carry out the analysis of variance (use the 0.05 significance level). Complete the analysis of variance table for the data set below. SS MS F Source Columns Rows Interaction Within Total (Round to two decimal places as needed.) Data Table Diagnosis I Diagnosis II Therapy A 5 1 7 Print Therapy B 7 12 Done Therapy C 4282…

Meredith Grey has asked every surgeon at Grey-Sloan Memorial Hospital the following question: "How many surgeries have you scrubbed in on in the past 30 days?" The results are shown below. Number of surgeries 30 40 50 50 90 55 70 70 85 55 70 85 85 55 65 80 60 85 70 80 75 85 135 90 80 85 95 50 75 75 Find the following measures of center. Mean = Median = Mode =

_________ are used to display actual data points for individual-level data. Would this answer be Univariate Statistics?

Consider the following data: −10, −10, 0, 3, −10, 3, 3  Step 1 of 3: Calculate the value of the sample Variance. Round your answer to one decimal place. Step 2 of 3: Calculate the value of the sample deviation. Round your answer to one decimal place. Step 3 of 3: Calculate the value of the range.