WHAT YOU NEED TO SUBMIT: Question1: Submit the answers in word document

WHAT YOU NEED TO SUBMIT:

Question1: Submit the answers in word document with all the necessary details (i.e. all the steps required for the hypothesis testing. Attach the necessary excel sheet with all the calculation visible.

Question2: Submit your rmd and .html output files.

Question1:

Perform ANOVA analysis using the manual method discussed in the class using excel. Show all the steps of hypothesis testing.

Use the dataset mtcars (you can get this dataset from R)

Test the ANOVA for mpg vs cyl.

Hint: Cycle is a categorical variable with different levels.

Question2:

Sodium Contents of Foods The amount of sodium (in milligrams) in one serving for a random sample of three different kinds of foods is listed here.

Condiments Cereals Desserts

270 260 100

130 220 180

230 290 250

180 290 250

80 200 300

70 320 360

200 140 300

160

Using R studio, answer these questions:

At the 0.05 level of significance, is there sufficient evidence to conclude that a difference in mean sodium amounts exists among condiments, cereals, and desserts? Formally test this hypothesis.

If the answer to #1 is yes, perform a post-hoc test to determine which means are different?