An automobile club reported that the average price of regular gasoline in a certain state was $2.83 per gallon. The following data show the price per gallon of regular gasoline for 15 randomly selected stations in the state. Complete parts a through c below

a. Construct an 80​% confidence interval to estimate the average price per gallon of gasoline in the state.

Answer: ​The 80% confidence interval to estimate the average price per gallon of gasoline in the state is from ​$2.78 per gallon to ​$2.85 per gallon.

b. Do the results from this sample validate the automobile​ club's findings?

Answer: First determine whether the population​ mean, 2.83​, is contained within the 80 % confidence​ interval, which is approximately from 2.78 to 2.85.

Note that 2.83 is contained within the 80 % confidence interval.

To determine whether the results from this sample validate the automobile​ club's findings, recall that a confidence interval for the mean is an interval estimate around a sample mean that provides one with a range of where the true population mean lies.

c. What assumptions need to be made about this​ population?

Answer: Carefully review the requirements for calculating a confidence interval with the​ Student's t-distribution when the sample size is less than or equal to 30.

Above are the questions and answers. Please provide all Excel formulas (not calculations) that get to these answers.

A factory produces plate glass with a mean thickness of 4mm and a standard deviation of 1.1mm. A simple random sample of 100 sheets of glass is to be measured, and the mean thickness of the 100 sheets is to be computed.

What is the probability that the average thickness of the 100 sheets is less than 3.91 mm?

Compare answer A and B and give comment on any change occurred between year 2005 to 2015.

A) Ratio of GDP per capita (Middle to high wages) -2005 year.

i. 3980/38293=0.1039*100=10.4%

ii. Ratio of GDP per capita (low to high wages)

507/ 38293=0.013*100=1.3%

             iii. Ratio of GDP per capita (low to middle wage)

507/3980=0.127*100=12.7%

B) i. Ratio of GDP per capita (Middle to high wages)- 2015 year

154192.5/77024.76 = 2.00 *100= 200%

ii. Ratio of GDP per capita (low to high wages)

I 5085.24/77024.76 = 0.066 *100 =6.6%

iii. Ratio of GDP per capita (low to middle wages)

5085.24/154192.5 = 0.033 *100=3.3%

A researcher is interested in a possible relationship between height and the time it takes to run a 100 meters. With a random sample of 57 people, the researcher finds a Pearson correlation coefficient r = − 0.492.

Group of answer choices

A. There is a very strong correlation between these variables. As height increases, generally the 100-meter run time decreases.

B. There is a very strong correlation between these variables. As height increases, generally the 100-meter run time increases as well.

C. There is no correlation between these variables. As height increases, there is no general trend in what happens with the 100-meter run time.

D. While not very strong, there is a moderate correlation between these variables. In general, as height increases, the 100-meter run time will also increase.

E. While not very strong, there is a moderate correlation between these variables. In general, as height increases, the 100-meter run time will decrease.

ITP100 Project: Part 3 Create the pseudocode solution to a program that calculates the final score and letter grade for one student. Please use the following grading system: 9 Homework Assignments – 100 points each 10 points 11 Quizzes – 100 points each 5 points 5 Projects – 100 points each 10 points 6 Discussion posts – 100 points each 10 points 4 Exams – 100 points each 65 points A = 90 – 100% B = 80 – 89% C = 70 – 79% D = 60 – 69% F = 0 – 59% Modify part 2 of the project by including repetitive structures, functions and input validation (Chapters 5, 6 and 7). Try to reduce your code by reusing functions or modules that perform similar tasks. Do not use arrays.

You are asked to value Houston Inc.'s common equity.

Assume that Houston Inc. is a constant growth company with a required rate of return of 13 percent whose last dividend (D0, which was paid yesterday) was $2.00, and whose dividend is expected to grow indefinitely at a 7 percent rate.

a. What is the firm’s expected dividend stream over the next 3 years?                         
b. What is the firm’s current stock price?
c. What is the stock's expected value 1 year from now?            
d. What are the expected dividend yield, the capital gains yield, and the total return for Houston Inc. during the first year.