Use Excel to determine whether the variables mentioned in the two problems below are independent or not. Clearly state the 4 steps in Hypothesis Testing as discussed: Step 1: The hypotheses are written in words. Step 2: Find the alpha in the problem Step 3: Make a screenshot of the Excel calculations are results as shown in the video. Step 4: Make a decision based on the value found in Step 3 and make a conclusion. Consolidate these steps in Word file and submit as one document. 1. The results of a random sample of children with pain from musculoskeletal injuries treated with acetaminophen, ibuprofen, or codeine are shown in the table. At α = 0.10, is there enough evidence to conclude that the treatment and result are independent?   Acetaminophen Ibuprofen Codeine TOTAL Significant Improvement 58 81 61 200 Slight Improvement 42 19 39 100 TOTAL 100 100 100 300

Q: Anna warted to test the effect of a popular energy drink an alertness. To do this, she recruited 12…

A: Given the data of alertness scores of energy drink and soft drink asEnergy DrinkSoft…

Q: QUESTION 11 For an experiment with 3 groups of 10 participants in each group. dfB = O 2 30 4.

A:

Q: General Direction: Perform each of the following steps. a. Find the Spearman rank correlation…

A: The spearman rank correlation coefficient (r) formula is defined as shown below…

Q: Two suppliers manufacture a plastic gear used in a laser printer. The impact strength of these gears…

A: Given that, A random sample of 10 gears from supplier 1 results in x₁ = 290 and s₁ = 12, and another…

Q: The three basic requirements of valid experiments( Under Control, Independent Variable, and…

A:

Q: Taxpayers who go to a treasury office to pay their contributions complain that they wait more than 7…

A:

Q: For this scenario, write out the hypotheses to be put to the test and define the parameter of…

A: Given that  The World Bank, 10.7 percent of the world's population lived in poverty in 2013.…

Q: You are the manager for a family medicine clinic that has 3 physicians.  The staff have come to you…

A: In order to determine whether there is significant difference in between the mean number of patients…

Q: e codes to write them in R studio. See attached pic. Course name: probability and statistics for…

A: a) to extract the second row  R code = tablename[2,] output = 18.6      56.23   b) to extract fourth…

Q: “Snoqualmie” is a name shared by a waterfall and a tribe of Native Americans. In a study of the…

A: The provided data is,

Q: A company that manufactures golf balls produces a new type of ball that is supposed to travel…

A: Given : A company that manufactures golf balls produces a new type of ball that is supposed to…

Q: When comparing simulation solutions to analytical solutions, which of the following are considered…

A: Because  comparison of simulated vs analytical results in research related to computer communication…

Q: Suppose that a national survey finds that 73 percent of restaurant employees say that work stress…

A:

Q: plot back-to-back with the previous stemplot. For #5, make your boxplots side-by- side. PART II:…

A: Hi! Thank you for the question, As per the honour code, we are allowed to answer three sub-parts at…

Q: University students were asked if they agreed that their education was worth the cost. One variable…

A: Given that: X Y 28 52 29 58 30 61 37 54 45 53 47 61 52 54 54 62 57 69 60 58…

Q: 2. You are studying a species of fruit fly which is believed to have a normally distributed wingspan…

A: 2) Given Information: Mean μ=4 Standard deviation σ=0.3 Sample size n=78 Sample mean x¯=4.1 Level of…

Q: our friend, Stan Darderror, recently completed a cognitive ability test as part of his assessment…

A: The critical value is the value of the test statistic which separates the critical region and the…

Q: C2. Construct potential hypotheses or research questions to relate the variables in each of the…

A: As per guidelines we will only answer the first three subparts, please repost other subparts for…

Q: In 2010, the proportion of students that worked was 75%. A researcher thinks the proportion has…

A: Givensample size(n)=91x=70sample proportion(p^)=xn=7091≅0.7692significance leve(α)=0.10

Q: Make 1 real-life problem with a solution in any of the following topics; 2. Preforming hypothesis…

A: A paired t test is used when the study is interested in difference between two variables with…

Q: A researcher has participants expecting to receive either painful or mild electrical shocks during a…

A: Usually in survival analysis studies we can use both parametric and non-parametric statistics. For…

Q: Please see below. I need to see if this is correct and whether there is another way to find the…

A: Given that  Sample size n =100 Favorable cases x =7 Sample proportion p^=x/n

Q: Problem: A manufacturer conducts a concept test to predict market share for a new product. The…

A: ANSWER:-  Here, our hypothesis is, H0 : P=0.10  VS   H1 : P >=0.10 Test statistic: Z= (p -…

Q: Decide whether each of the following statements make sense, or is clearly true, or does not make…

A: ### Step 1: Understand the Null HypothesisThe null hypothesis (denoted as H_0 in a study typically…

Q: Is there a particular acid reflux drug that is more effective? To answer this question, we will use…

A: The test statistic is given below: χ2=∑Oi-Ei2Ei   Here, Oi represents the observed values Ei…

Q: Problem #3: An auto manufacturer makes a type of car that is known to have an average mileage of…

A: The known average mileage of the car on the highway is  mpg.A smaller engine is given in the car to…

Q: Home Runs Two mples of Hai Baseball players wer selected and of home runs hit were recorded. One…

A: From the given information we conduct Hypothesis test.

Q: You pick up your iPhone to send your best friend a text and the iPhone is not working; the screen is…

A: Here, hypothesis testing process. Theory, experiment....... Conclusion. We will arrange in order.

Q: I want to know if being an athlete or not would change the resuls to the donut vs. bagel study. I…

A: Given information isIt is a study of donut vs. bagel There are two…

Q: Use the traditional method in testing the hypothesis in the problems below. In each problem, state…

A:

Q: Could you please highlight the correct answer. and explain it

A: The null hypothesis for a chi square independence test say that two categorical variables are…

Q: A report summarizing scores for students on a verbal aptitude test x and a math aptitude test y…

A: The variable x denotes verbal aptitude test and the variable y denotes math aptitude test.

Q: Read through this scenario and look at the data that was collected.  State the null and all possible…

A: Provided ANOVA result with replication

Q: Beachcomber Ltd in a local car dealership that sells used and new vehicles. The manager of the…

A: The null and alternative hypothesis for regression analysis claims that the model is ineffective and…

Q: part d only

A: The one way ANOVA is used for testing the differences between means of more than two groups. It is…

Q: The following table includes the weekly study time and exam result for each student in a…

A: The table of given data is as follows: Hours of Study Per Week Exam Score (out of 100) 6.5 90…

Q: According to the most recent General Social Survey, 70% of adults watch TV nightly. A researcher…

A:

Q: Many questions in research can be expressed as two competing statements about the population…

A: Given that, 40% of all supermarkets in the US use recyclable plastic bags. The researcher wants to…

Q: PLEASE COMPLETE STEP 1 TO 5 and DO NOT USE EXCEL. Step 1. State Ha and Ho Step 2. Level of…

A: Hi! Thankyou for the question. As per the guidelines, we are allowed to answer only the first…

Q: This is the step1, so step 2 and step 3 and Step 4 must be answered. (Step 2: Test Statistic…

A: Null Hypothesis: Ho: r = 0; There is no significant relationship between the number of hours spent…

Q: Chi Square Two Sample An agency director would like to determine whether there is a significant…

A: