Using a regression model in excel to understand the factors that contribute to customer satisfaction and spending. Refer to the data provided to identify what variables are significant to predicting overall satisfaction. Develop and interpret the prediction equation and the coefficient of determination. Based on the data, what areas should the business focus on to improve customer satisfaction?

4. Listed below are the combined city – highway fuel consumption ratings (in miles per gallons) for different cars measured in old rating system and cars in a new rating system introduced in 2008 (based on data from USA today). A. Construct a 90 percent confidence interval of the difference in the ratings of cars. (Use 3 decimal places) (10 pts) Old Rating: 16 18 27 17 33 28 33 18 24 19 18 27 22 18 20 29 19 27 20 21 New Rating: 15 16 24 15 29 25 29 16 22 17 16 24 20 16 18 26 17 25 18 19 B. Based on the interval is there a reason to believe that there is a difference in the ratings of the two cars? C. Is there any significant difference in the old and new ratings of cars? Use appropriate hypothesis test to answer this question.

Question text

7-step Hypothesis Testing Problem

Complete the 7 steps in Excel and upload the file here

Two major automobile manufacturers have produced compact cars with the same size engines.We are interested in determining whether or not there is a significant difference in the MPG (miles per gallon) of the two brands of automobiles.A random sample of eight cars from each manufacturer is selected, and eight drivers are selected to drive each automobile for a specified distance.The following data show the results of the test.

At the 0.05 level of significance, conduct a 7-step hypothesis test to determine whether there is a significant difference in the MPG (miles per gallon) of the two brands of automobiles.

The following selected transactions were completed by Capers Company during October of the current year:

Journalize the entries to record the transactions of Capers Company for October. Refer to the Chart of Accounts for exact wording of account titles.

Problem 4S-1

Consider the following system:

→ 0.74 → 0.74 →

Determine the probability that the system will operate under each of these conditions:

a. The system as shown. (Do not round your intermediate calculations. Round your final answer to 4 decimal places.)

Probability              

b. Each system component has a backup with a probability of .74 and a switch that is 100% percent reliable. (Do not round your intermediate calculations. Round your final answer to 4 decimal places.)

Probability            

c. Backups with .74 probability and a switch that is 99 percent reliable. (Do not round your intermediate calculations. Round your final answer to 4 decimal places.)

Probability            

can someone explain why this is wrong: The proportion of middle-aged males and middle-aged females who have committed suicide in 1999 are even and equal (P1=P2). and can you include the Confidence interval, Critical Z, and P-Value?

Middle age= 45-64

The following data represent the serum HDL cholesterol of the 45 patients of a family doctor.

41 62 67 60 54 48 75 69 60 54 43 77 69 60 55 38 58 70 61 56 35 82 65 62 56 44 55 74 64 58 44 85 74 64 57 37 39 72 63 56

(a) Compute the population mean and standard deviation.

(b) Draw a histogram to verify the data is bell-shaped.

(c) Determine the percentage of patients and also the total number of patients that have serum HDL between 40.72 and 83.53 according to the Empirical Rule

The age x and resting heart rate y were measured for ten men, with the results shown in the table.

Test, at 10% level of significance, whether age is useful for predicting resting heart rate.

H₀:

H_a:

t-Test Statistic (round to three decimal places) =

Critical t-score (t αt α or t α / 2t α / 2, round to three decimal places) =  

Conclusion (write "R" for reject H₀, and "F" for fail to reject H₀):

In C# The Saffir-Simpson Hurricane Scale classifies hurricanes into five categories numbered 1 through 5. Write an application named Hurricane that outputs a hurricane’s category based on the user’s input of the wind speed. Category 5 hurricanes have sustained winds of at least 157 miles per hour. The minimum sustained wind speeds for categories 4 through 1 are 130, 111, 96, and 74 miles per hour, respectively. Any storm with winds of less than 74 miles per hour is not a hurricane. If a storm falls into one of the hurricane categories, output This is a category # hurricane, with # replaced by the category number. If a storm is not a hurricane, output This is not a hurricane.

Assume that the 129 patients in the Patients dataset (Excel) represent the entire population of interest. If you were interested in age of the patients and took a sample of 25 patients from this population, what is the standard error of the mean?   What if you took a sample 64 patients from this population, what is the standard error of the mean? What happens to the standard error of the mean as the sample size increases? Why does that make logical sense?

Mean 75