O Macmillan LearningTwo different methods were used to measure the amount of water (mg/mL) in an organic solvent. The results are given inthe table.tcalculatedUse the built in statistical tools of Microsoft Excel to determine if the results of the two methods are statistically equivalent atthe 95% confidence level. Assume the standard deviations are statistically equivalent. Report the values of tcalculated and ttable.ttableMethod 10.0127980.0130150.0129870.0128880.013004IncorrectIncorrectMethod 20.0129980.0130010.0130210.0128410.012584Do the two methods give statistically equivlent results at the 95% confidence level?

The data is about the amount of water in an organic solvent.Put the data into Excel as…

Answered: Two different methods were used to…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

PLEASE DO IN Excel A clinical trial is run to assess the effects of different forms of regular exercise on HDL levels in persons between the ages of 18 and 29. Participants in the study are randomly assigned to one of three exercise groups - Weight training, Aerobic exercise or Stretching/Yoga – and instructed to follow the program for 8 weeks. Their HDL levels are measured after 8 weeks and are summarized below. Is there a significant difference in mean HDL levels among the exercise groups? Run the test at a 5% level of significance. HINT: SSerror = 7286.5. Exercise Group N Mean Std Dev Weight Training 20 49.7 10.2 Aerobic Exercise 20 43.1 11.1 Stretching/Yoga 20 57 12.5 Step 1. Set up hypotheses and determine level of significance. Ho: H1: alpha: Step 2. Select the appropriate test statistic and give its formula.…
solve for image and find critical values
*PLEASE show in excel A different investigator conducts a second study to investigate whether there is a difference in mean PEF in children with chronic bronchitis as compared to those without. Data on PEF are collected and summarized below. Based on the data, is there statistical evidence of a lower mean PEF in children with chronic bronchitis as compared to those without? Run the appropriate test at a=0.05. Group Number of Children Mean PEF Std Dev PEF Chronic Bronchitis 25 281 68 No Chronic Bronchitis 25 319 74 Step 1. Set up hypotheses and determine level of significance. Ho: H1: alpha: Step 2. Select the appropriate test statistic and give its formula. Step 3. Set up decision rule. Step 4. Compute the test statistic Step 5. Conclusion.
Use the 1odwing Wildlife: Coyotes A random sample of 46 adult coyotes in a region of northern Minnesota showed the average age to be z = 2.05 years, with sample standard deviation 8 = 0.82 years (based on information from the book Coyotes: Biology, Behavior and Management by M. Bekoff, Academic Press). However, it is thought that the overall population mean age of coyotes is µ=1.75. Do the sample data indicate that coyotes in this region of northern Minnesota tend to live longer than the average of 1.75 years? Use a = 0.01. Fl in the blanks a 007 • Ho u- 175 years * H u> 176 yean QUESTION 7 What is your test statistic? (t-statistic) 2.48 QUESTION 8 What is your p-value? (Hint You will need the degrees of freedom to find the p-value.) <0.01d QUESTION 9 Do you reject the null hypothesis? O Yes No
Individual scores for practices towards COFLU-20 are found to be normally distributed with a mean of 3 and a standard deviation of 1.5 over the entire population. The Ministry of Health wishes to use this information to identify individuals whose score on practices towards COFLU20 is in the lower 75%, in order to give them relevant information on the best practices towards COFLU-20. You are asked to assist in calculating the score that the Ministry of Health should use to decide whether an individual should be given the relevant information?
In Arkansas, bass fish were collected in 30 different lakes to measure the amount of mercury in the fish. The mean amount of mercury was = 0.6443 with standard deviation s = 0.3606. Estimate the mean amount of mercury in fish in Arkansas lakes using a 95% confidence level. Round your answers to three decimal places, and use four decimal places for any interim calculations. With 95 % confidence, it can said that the true mean amount of mercury in fish in Arkansas lakes is between 0.502 x and 0.786 X Hint: Make sure you round your answer to three decimal places.
Big babies: The National Health Statistics Reports described a study in which a sample of 96 one-year-old baby boys were weighed. Their mean weight was 25.6 pounds with standard deviation 5.3 pounds. A pediatrician claims that the mean weight of one-year-old boys is greater than 25 pounds. Do the data provide convincing evidence that the pediatrician's claim is true? Use the =α0.05 level of significance and the P -value method and Excel. Part: 0 / 5 0 of 5 Parts Complete Part 1 of 5 (a)State the appropriate null and alternate hypotheses. H0 : =μ25 H1 : >μ25 This hypothesis test is a ▼two-tailed test. Part: 1 / 5 1 of 5 Parts Complete Part 2 of 5 (b)Compute the value of the test statistic. Round the answer to at least three decimal places.…
A standard method for the determination of glucose in serum is reported to have a standard deviation of 0.37 mg/dL. If s = 0.37 is a good estimate of o, how many replicate determinations should be made in order for the mean for the analysis of a sample to be within (This problem requires values in your textbook's specific appendices, which you can access through the OWLV2 MindTap Reader. You should not use the OWLV2 References' Tables to answer this question as the values will not match.) Remember that you always need to round your final answer up to a whole number of replicates. a. 0.3 mg/dL of the true mean 99% of the time? b. 0.3 mg/dL of the true mean 95% of the time? c. 0.2 mg/dL of the true mean 90% of the time?
A simple random sample of 195 males was taken and their birth weights measured. The sample had a mean of 3272.8 g and standard deviation of 660.2 g. Use a 0.01 significance level to test the claim that the population mean of birth weights of males is less than 3400 g. Use the p-value method. Include a diagram of the distribution indicating important components of the question.
A survey was conducted to measure the height of Canadian men. In the survey, respondents were grouped by age. In the 20-29 age group, the height was normally distributed, with a mean of 69.2 inches and a standard deviation of 2.9 inches. A study participant is randomly selected. Find P80, the 80th percentile Find P50, the 50th percentile Find the height that corresponds to the first quartile please show all steps using excel formulas
A sample of 6 credit ratings for car loan applicants has a mean of 602 and a variance of 4356. Use the data toconstruct a 90% confidence interval for the population standard deviation of credit scores for all applicantsfor car loans. What is the Best point estimate and Include the written statement

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS