please show all steps USING EXCEL ONLY FORMULAS ADEFHKMNQ1Type of testНа2rejectHoIn you work for a real estate company, you find thata sample of 1762 homepbuyers, 722 found their real estate agent through a friend. At a = 0.02, can youreject the claim that 44% of home buyers find their real estate agent through afriend?3 alpha4 alpha/2critical value56 poTest statistic7 9o=1-p.910 o or sP-value111213 sqrt(p.*q./n)1415decision16171819conclusion20

Answered: show all steps USING EXCEL O

Math

Statistics

show all steps USING EXCEL O

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section10.1: Measures Of Center

Problem 9PPS

See similar textbooks

Similar questions

Athabasca Fishing Lodge is located on Lake Athabasca in northern Canada. In one of its recent brochures, the lodge advertises that 75% of its guests catch northern pike over 20 pounds. Suppose that last summer 64 out of a random sample of 83 guests did, in fact, catch northern pike weighing over 20 pounds. Does this indicate that the population proportion of guests who catch pike over 20 pounds is different from 75%? Use alpha = 0.05.
Bo is buying some nails for a project. They are interested in whether the boxes are significantly lower than advertised. The company says the box of nails should weigh 10 lbs but Bo finds the average weight of 8 boxes id 9.8 lbs with a SD of .4 lbs. assume alpha of .10. What is the test statistic?
The table below shows the weight in pounds for a sample of vacuum cleaners. The weights are classified according to vacuum cleaner type. At alpha - 0.01 can you conclude that at least one mean vacuum cleaner weight is different from the others? Bagged upright Vaccum – 21,22,23,21,17,19 Bagless upright – 16,18,19,,21,20 Top canister – 26,24,23,25,27,21
The median pH level of the rain in a certain county, was 4.90. A biologist obtains a random sample of 19 rain dates and obtains the following data. Test the hypothesis that the median pH level has decreased from 4.90 at the alpha= 0.05 level of significance.
The average age of licensed drivers in a county is µ = 42.6, s= 10, and the distribution is approximately normal. A county police officer was interested in whether the average age of drivers receiving parking tickets differed from the average age of the driving population. She obtained a sample of N = 100 drivers receiving parking tickets. The average age of these drivers was M = 40.6. Say the researcher wants to determine whether this group differs from the population of drivers in the county. Use an alpha level of 0.05 (zcrit=1.96 (two-tailed test)/ zcrit=1.65 (one-tailed test)). 31. What are the null and alternative hypotheses? 32. What is the z statistic associated with this case? 33. Using the z critical information available, draw a normal distribution and fill in the observed z statistic, z critical and make the decision for the hypotheses based on the available information.
Sal knows that parties of people on average spend 75 minutes at their restaurant. They wonder if this average is significantly different on the weekends. They found the average time spent by the 30 parties which dined there this weekend was 82 minutes with a SD of 17 minutes. Assume an alpha of .05. What is the test statistic?
tstat plz You are testing the null hypothesis that there is no relationship between two variables, X and Y. From your sample of n=18, you determine that SSR=60 and SSE=20. Complete parts (a) through (e) below. a. What is the value of FSTAT? State the hypotheses to test. Choose the correct answer below. A. H0: β1≤0 H1: β1>0 B. H0: β1=0 H1: β1≠0 Your answer is correct. C. H0: β1≠0 H1: β1=0 D. H0: β1≥0 H1: β1<0 FSTAT=4848 (Round to the nearest integer as needed.) b. At the α=0.05 level of significance, what is the critical value? The critical value is 4.494.49. (Round to two decimal places as needed.) c. Based on your answers to (a) and (b), what statistical decision should you make? A. Do not reject H0. There is evidence that there is a relationship between X and Y. B. Reject H0. There is evidence that there is a relationship between X and Y. Your answer is correct. C.…
You are conducting a hypothesis test where the null hypothesis is that mu is less than or equal to 850. You are testing at the 0.01 significance level. You take a sample of size 64 and calculate your test statistic to be -1.50. What would your test statistic be if, rather than mu<= 850, your null hypothesis was that mu >= 850?
I want to assess whether different types of movies increase viewers’ stress response. I recruit 24 individuals and randomly assign them into three groups: Frozen (a Disney kids movie), Nightmare on Elm Street (a horror movie), and Fast & Furious (an action movie). After each participant watches their assigned movie, I measure their heart rate. Test, at an alpha of 0.05, whether the type of movie affects heart rate. What is the null hypothesis? What is the alternative hypothesis? Data: Frozen DV: Heart Rate (BPM) Nightmare on Elm Street DV: Heart Rate (BPM) Fast & Furious DV: Heart Rate (BPM) 65 90 85 70 85 85 70 86 75 65 92 90 62 93 60 63 97 63 68 105 74 72 110 80 What is the between-groups degrees of freedom (df)? What is the within-groups degrees of freedom (df)? What is the total degrees of freedom (df)? What is our critical F value (from table)? Fill in the…
A veterinary nutritionist developed a diet for overweight dogs. The total volume of food consumed remains the same, but one-half of the dog food is replaced with a low-calorie “filler” such as canned green beans. Six overweight dogs were randomly selected from her practice and were put on this program. Their initial weights were recorded, and they were weighed again after 4 weeks. The results of the experiment are shown below. At α=0.05, can it be concluded that the dogs significantly lost weight?
A researcher examines whether an over the counter cold medication has an effect on mental alertness. A sample of n=16 participants is obtained, and each person is given a standard dose of the medication one hour before being tested on a driving simulation task. For the general population, scores on the simulation task are normally distributed with a µ = 60 and s=8. The sample scores an average of M=56. Can the researchers conclude that the scores on the driving simulation task are significantly different after taking the medication? (test at alpha = .05 and show all of the steps of hypothesis testing)
In a test of Ho: µ = 85 against Ha: u > 85, the sample data yield the sample statistic z = 1.64. Find the p-value for the test. Compute it manually, not excel.