The Conch Café, located in Gulf Shores, Alabama, features casual lunches with a great view of the Gulf of Mexico. To accommodate the increase in business during the summer vacation season, Fuzzy Conch, the owner, hires a large number of servers as seasonal help. When he interviews a prospective server, he would like to provide data on the amount a server can earn in tips. He believes that the amount of the bill and the number of diners are both related to the amount of the tip. He gathered the following sample information.

CustomerAmount of TipAmount of BillNumber of DinersCustomerAmount of TipAmount of BillNumber of Diners

  Click here for the Excel Data File

a-1. Develop a multiple regression equation with the amount of tips as the dependent variable and the amount of the bill and the number of diners as independent variables and complete the table. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)

a-2. Write out the regression equation. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)

a-3. How much does another diner add to the amount of the tips? (Round your answer to 2 decimal places.)

b. According to the p-values, which variable should be deleted if alpha = 0.05?

#14 . Listed below are speeds (mi/h) measured from southbound traffic on I-280 near Cupertino, CA. This simple random sample was obtained at 3:30 p.m. on a weekday. Use a 0.05 significance level to test the claim of the highway engineer that the standard deviation of speeds is equal to 5.0 mi/h. (With a 95% confidence) 62 61 61 57 61 54 59 58 59 69 60 67

A) Construct a confidence interval using the confidence level provided.

B) Test the hypothesis

C) Enter the results in excel as following

confidence level critical value confidence interval

   XL^2

   XR^2

General Electric recently conducted a study to evaluate filaments in their industrial high intensity bulbs. Investigators recorded the number of weeks each high-intensity bulb would last before failure for three test filaments (Groups 1, 2, and 3) and the standard filament (Group 4). The results are as follows. Using ? = 0.01,

Group       1          2       3        4

                 15       14     25     28

                 18       18     19     31

                 21       20     22     27

                 16       16     20     32

                 17       15     18     23

                 20       16     24     25

                18         22     27     30

                              14    18     27     

                                      24     25

                                               26

1. Write an appropriate ANOVA hypothesis to test the difference in means of the four groups (null and alternative).
2. Read the data into R or R-studio, run an ANOVA model in R and paste the code used as well as the output here. What is the decision based on the ANOVA test? You need to explain what part of the output led you to the conclusion you made.
3. Continue using R: Use the Tukey method to test all pairwise contrasts. Show the R code, output, and explain the results of all the comparisons in complete sentences while referencing the parts/numbers on the output that support your conclusions.

What is the Poisson Regression?

Why is the Standard Deviation an important Business Metric?

How do business leaders and researchers use the Expected Value?

1. A salsa producer has just received a shipment of tomatoes from their main supplier. If the salsa
company finds convincing evidence that more than 7% of the tomatoes are damaged and
unusable for the salsa making process, the truck will have to be sent away and a new shipment
will have to be sent out by the supplier. An inspection reveals that 49 tomatoes are unusable
when the supervisor selects a random sample of 500 tomatoes from the truck. Carry out a
significance test at the α = 0.05 significance level. What should the salsa producer conclude
about the shipment?

2. As part of the Southeastern Region of Teach America, researchers conducted two surveys in
2019. The first survey asked a random sample of 1287 Florida college students about their use of
online tutoring services. A second survey posed similar questions to a random sample of 1354
Georgia college students. In these 2 studies, 57% of Florida college students and 68% of Georgia
college students said they used online tutoring services. Construct and interpret a 90%
confidence interval for the difference between the proportion of Florida and Georgia college students who use online tutoring services

A psychologist interested in examining workplace stress recruits 30 adults and administered a stress questionnaire to them. The questionnaire’s scores ranged from 0-20 with lower scores indicating lower amounts of stress and higher scores indicating significant amounts of stress. On average, workers tend to score a 10. Results from this questionnaire showed workers at this company on average scored 15 with a standard deviation estimate of 3.96. Test the viability that µ = 10 using a one-sample t-test

Please use minitab, and show the steps to get to the solution. Meaning: Go to Stat, basic statistics, etc, etc.

Forty sewage samples a waste water treatment plant were collected from a recent EPA report. The ppm of suspended solids in each specimen is presented in the following table. (a) Examine descriptive statistics of the mean, median, standard deviation, first quartile, third quartile, minimum value, and maximum value. What do these statistics indicate about the shape of the population distribution? (b) Create a histogram with binning center points at 30, 40, 50, 60, 70, 80, 90, and 100. What does the shape of the histogram tell of about the shape of the population distribution? (c) Construct a normal probability plot, a lognormal probability plot, and a Weibull probability plot of these data. Allow Minitab to estimate the best fit parameters for each distribution. Based on the plots and associated Anderson-Darling (AD) fit statistics, identify which distribution seems to be the best fit model at α = 0.05 for suspended solid material (ppm) in water. 59.4 44.3 55.4 39.9 50.8 45.9 53.4 80.7 68.8 40.3 49.5 64.5 48.4 82.4 33.6 75.3 37.4 50.6 62.7 56.2 86.8 42.7 44.2 30.7 43.4 50.9 44.8 69.1 102.2 53.1 68.9 43.6 59.1 79.6 90.7 51.6 71.2 55.3 59.6 50.8

People were polled on how many books they read the previous year. Initial survey results indicate that s equals 17.4 books. Complete parts ​(a) through ​(d) below.

a. How many subjects are needed to estimate the mean number of books read the previous year with 90​% ​confidence?

this 90% confidence requires ___ subjects?

b. How many subjects are needed to estimate the mean number of books read the previous year within three books with 90% confidence?

this 90% confidence requires ___ subjects?

c. How many subjects are needed to estimate the mean number of books read the previous year within six books with 99% confidence?

this 99% confidence requires ___ subjects?

8.

A sample of 400 observations will be taken from an infinite population. The population proportion equals 0.8. The probability that the sample proportion will be greater than 0.83 is

Select one:

a. 0.4332

b. 0.0668

c. 0.9332

d. 0.5668

9.

Four hundred people were asked whether gun laws should be more stringent. Three hundred said "yes," and 100 said "no". The point estimate of the proportion in the population who will respond "yes" is

Select one:

a. 300

b. approximately 300

c. 0.75

d. 0.25

Directions: Use SPSS to compute the Regression Line.

Problem: Using the following set of data and Excel, compute the regression line. The data set represents the number of hours of training to predict how severe injuries will be if someone is injured playing football. Briefly summarize your findings.

1. IDENTIFY THE INDEPENDENT AND DEPENDENT VARIABLES
2. IDENTIFY THE REGRESSION LINE Y’
3. WHAT IS THE P-VALUE?
4. IF THE P-VALUE SIGNIFICANT?
5. DO YOU ACCEPT OR REJECT THE NULL?
6. WHAT DOES YOUR DECISION MEAN?

A hospital conducted a study of the waiting time in its emergency room. The hospital has a main campus and three satellite locations. Management has a business objective of reducing waiting time for emergency room cases that do not require immediate attention. To study this, a random sample of 15 emergency room cases that did not require immediate attention at each location were selected on a particular day, and the waiting time (measured from check-in to when the patient was called into the clinic area) were collected and stored in ER.

a. At the 0.05 level of significance, is there evidence of a difference in the mean waiting times in the four locations?

b. Does the result in (a) give you statistical permission to probe for individual differences between hospital locations?

I WANT THE ANSWER IN EXCEL USING THE DATA ANALYSIS....DO NOT PROVIDE A HAND WRITTEN ANSWER...I'm trying to understand the functions in excel

For this problem, carry at least four digits after the decimal in your calculations. Answers may vary slightly due to rounding. In a combined study of northern pike, cutthroat trout, rainbow trout, and lake trout, it was found that 24 out of 851 fish died when caught and released using barbless hooks on flies or lures. All hooks were removed from the fish.

(a) Let p represent the proportion of all pike and trout that die (i.e., p is the mortality rate) when caught and released using barbless hooks. Find a point estimate for p. (Round your answer to four decimal places.)

(b) Find a 99% confidence interval for p. (Round your answers to three decimal places.)

lower limit

upper limit

Give a brief explanation of the meaning of the interval.

1% of the confidence intervals created using this method would include the true catch-and-release mortality rate.

1% of all confidence intervals would include the true catch-and-release mortality rate.

99% of the confidence intervals created using this method would include the true catch-and-release mortality rate.

99% of all confidence intervals would include the true catch-and-release mortality rate.

(c) Is the normal approximation to the binomial justified in this problem? Explain.

Yes; np > 5 and nq > 5.

No; np > 5 and nq < 5.

No; np < 5 and nq > 5.

Yes; np < 5 and nq < 5.

Suppose that you belong to a panel with representatives from the Ministry of the Environment and the Accreditation Services Branch of the Standards Council of Canada. You are responsible for testing scrubbers, i.e. devices to capture carbon dioxide from smokestacks. You do so by measuring how much carbon dioxide they capture in a standard lab setting.

A manufacturer has stated, "When our Scrubber 2 is installed in the standard lab setting, the amount of carbon dioxide captured follows a normal distribution with a mean of more than 800 tons." You are responsible for verifying this. For five different Scrubber 2's, you record the following noisy data indicating the number of tons of carbon dioxide captured:

• 503, 854, 647, 701, 620

Question: Suppose that you're curious as to whether there's a difference between the Scrubber 2 and its predecessor, the Scrubber 1, in terms of the average amount of carbon dioxide captured. For four different Scrubber 1's, you take additional measurements in the standard lab setting:

• 683, 305, 377, 539

Consider the data set of now nine points. You do not wish to assume that either group follows a normal distribution. Would a randomization test be appropriate to assess the difference in means? If yes, run it and report your results. If no, suggest and perform an alternative.

State any assumptions you make.