Question

In: Statistics and Probability

The heating bills for a selected sample of houses in five different cities using various forms...

The heating bills for a selected sample of houses in five different cities using various forms of heating are given below (values are in dollars).

City	Gas Heated Homes	Central Electric	Heat Pump
Ankara	83	90	81
Konya	80	88	83
Çorum	82	87	80
Yozgat	83	82	82
Kırşehir	82	83	79

Is there a significant difference among the average bills of the homes according to the different heating methods? Test at 10% significance level by using one-way ANOVA method. (hint: using excel data analysis option (data/data analysis)).

What is the proper null hypothesis?
What is the proper alternative null hypothesis?
What is the value that represents the between group variation?
What is the value that represents the F ratio?
What is the value that represents the F critical?
What is your decision?

Is there a significant difference among the average bills of the homes according to the different cities? Test at 10% significance level by using one-way ANOVA method. (hint: using excel data analysis option (data/data analysis)).

What is the proper null hypothesis?
What is the proper alternative null hypothesis?
What is the value that represents the between group variation?
What is the value that represents the F ratio?
What is the value that represents the F critical?
What is your decision?

Prepare two-way ANOVA to repeat the tests at 10% significance level. (hint: using excel data analysis option (data/data analysis)).

What is the value that represents the F ratio for the test of equality of bills according to heating methods?
What is the value that represents the F ratio for the test of equality of bills according to cities?

(Note: If “data analysis” OPTION not loaded follow the below instructions to load)

Click àFile (or office button)

Choose à options

Choose à add-ins

Click à go

Mark à Analysis toolpack-VBA

Click à ok

When you click data tab you should see “data analysis” at the upper right corner of the tool bar.

Expert Solution

Answer 1.

a. Null Hypothesis, Ho; There is no significant difference among the average bills of the homes according to the different heating methods, i.e.

b. Alternative Hypothesis, Ha: There exists at least one heating method for which the average bill of homes is significantly different, i.e. there exists at least one for at least one

c. Between Group Variation = Sum of Squares Between Group = 70

d. F- ratio = 6.7742

e. F-critical = 2.8068

f. Since, F-ratio > F-critical, we Reject Ho at 10% level of significance and conclude that There exists at least one heating method for which the average bill of homes is significantly different, i.e. there exists at least one for at least one

Answer 2.

a. Null Hypothesis, Ho; There is no significant difference among the average bills of the homes across different cities, i.e.

b. Alternative Hypothesis, Ha: There exists at least one city for which the average bill of homes is significantly different, i.e. there exists at least one for at least one

c. Between Group Variation = Sum of Squares Between Group = 19.3333

d. F- ratio = 0.42899

e. F-critical = 2.6053

f. Since, F-ratio < F-critical, we fail to Reject Ho at 10% level of significance and conclude that There is no significant difference among the average bills of the homes across different cities, i.e.

Answer 3.

Answer a. F ratio for the test of equality of bills according to heating methods = Sum of Squares due to Columns = 6.5625

Answer b. F ratio for the test of equality of bills according to cities = Sum of Squares due to Rows = 0.90625

orchestra answered 2 years ago

1. The heating bills for a selected sample of houses using various forms of heating are...

1. The heating bills for a selected sample of houses using various forms of heating are given below (values are in dollars). Gas Heated Homes Central Electric Heat Pump 83 90 81 80 88 83 82 87 80 83 82 82 82 83 79 At alpha = 0.05, test to see if there is a significant difference among the average bills of the homes. Use both the critical and p-value approaches.

a.) A contractor wishes to lower heating bills by using a special type of insulation in...

a.) A contractor wishes to lower heating bills by using a special type of insulation in houses. The mean of the heating bill announced by the Energy Resource is 85. To determine if the special insulation will reduce heating costs, the contractor collects 20 heating bills from houses that already use the special type of insulation. The average of a heating bill for these 20 houses is 78. State the null and alternative hypotheses. b.) Treadlife of 2 brands of...

A simple random sample of 101 cities and counties in the United States was selected and...

A simple random sample of 101 cities and counties in the United States was selected and the number of positive COVID-19 cases per 1000 citizens was recorded for each. The mean number of positive cases for this sample of 101 counties and cities was 253, with a standard deviation of 11.4. Due to a couple of cities with extremely high numbers of cases the distribution is skewed heavily to the right. If appropriate, use this information to calculate and interpret...

A sample of 30 recently sold single-family houses in a small city is selected. Develop a...

A sample of 30 recently sold single-family houses in a small city is selected. Develop a model to predict the selling price (in thousands of dollars), using the assessed value (in thousands of dollars) as well as time (in months since reassessment). The houses in the city had been reassessed at full value one year prior to the study. The results are stored in House1.xls. a. State the multiple regression equation. b. Interpret the meaning of the slopes in this...

IN JAVA A salesman wants to go to five different cities and sell some products. The...

IN JAVA A salesman wants to go to five different cities and sell some products. The locations of the cities are listed in the following table. City # X_location Y_location City 1 1 1 City 2 1 3 City 3 4 1 City 4 5 3 City 5 3 5 The distance between two cities is defined as the Euclidean distance. That is: Distance = sqrt( (x1 – x2)^2 + (y1 – y2)^2 ) For example, the distance between cities...

Five to six times a year, Kicker puts on tent sales in various cities throughout Oklahoma...

Five to six times a year, Kicker puts on tent sales in various cities throughout Oklahoma and the surrounding states. The tent sales are designed to show Kicker customers new products, engender enthusiasm about those products, and sell soon to be out-of-date products at greatly reduced prices. Each tent sale lasts one day and requires parking lot space to set up the Kicker semitrailer; a couple of show cars; a disc jockey playing music; a tent to sell Kicker merchandise,...

A sample of starting salaries for bachelor degree level graduates in two different cities showed the...

A sample of starting salaries for bachelor degree level graduates in two different cities showed the following: City 1 City 2 n sample count 35 30 xbar sample average 60,000 58,000 s sample standard deviation 5,000 6,000 We do not know any population means or population standard deviations. Using alpha = .01 test whether the population average starting salaries are different.

10. There are a total of five different melanocortin receptors that are expressed in various tissues...

10. There are a total of five different melanocortin receptors that are expressed in various tissues of the human body. MC1R is, however, the only family member expressed in melanocytes. Using no more than one short paragraph (max 5 sentences) describe, from a molecular perspective, how MC1R but not the other MCRs are expressed in melanocytes.

2. Create a php program to get all the values from the forms using various methods...

2. Create a php program to get all the values from the forms using various methods and control structures like switch, if else, for, foreach, while, do while The question is required to write a program

In a group of 5 married couples, five different people are randomly selected. What is the...

In a group of 5 married couples, five different people are randomly selected. What is the probability of a couple being selected? Find the expected value of the number of couples selected among the five people.