Randomized block anova test using excel

Assignment Help Basic Statistics
Reference no: EM1397844

Use the following scenario. Develop two-null hypothesis tests to ascertain if there are any statistical variances in the averages of bus route times and any statistical variance among the average performance of the bus drivers. Use the following information to conduct the test:

The three bus routes are the treatments.

The three bus drivers are the blocks.

The common element is driving time.

Route 1 Time Route 2 Time Route 3 Time

Driver 1 24 minutes 21 minutes 27 minutes

Driver 2 28 minutes 27 minutes 25 minutes

Driver 3 18 minutes 13 minutes 19 minutes

2. Using any present or past job related data, perform an ANOVA in either Excel or MegaStat. Write your null and alternate hypothesis. Post your ANOVA table. Interpret the results.

Reference no: EM1397844

Questions Cloud

How courts have upheld rights of employer : Courts have upheld rights of employer to do this. Write down your thoughts about this? Should company be able to dictate behavior when you are in your own home?
Statistical analysis-analysis of variance : Advertisers need to know which age groups are likely to see their ads. Purchasers of 120 copies of Cosmopolitan are shown by age group.
Description of the genetic material and location : Describe what a prokaryote is and include a) a description of the genetic material and location, b) what type of organelles they have (if any), and c) if they have a cell wall, cell membrane, or both
What is the value of the population mean : What is the value of the population mean? What is the best estimate of the value?
Randomized block anova test using excel : Using any present or past job related data, perform an ANOVA in either Excel or MegaStat. Write your null and alternate hypothesis. Post your ANOVA table. Interpret the results.
What are the phenotype frequencies in this population : If you assume this population is a large, random mating population that is not undergoing evolution, what are the genotype frequencies? First, figure the allele frequencies in the gene pool.
Iron hydroxide and lithium nitrate solution : Iron (III) nitrate solution reacts with lithium hydroxide solution to produce solid iron (III) hydroxide and lithium nitrate solution.
What is the relationship between infection and the spleen : What is the relationship between infection and the spleen?
Determine order of action of genes etr1, ctr1 and ein : Design an experiment to determine order of action of genes ETR1, CTR1 and EIN in ethylene signalling? Also design an experiment to see whether ETR1 interacts with CTR1 or not?? give a brief overview of the experiments.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Standard deviation of two ounces

There are 4000 mangoes in a shipment. It is found that it a mean weight of 15 ounces with a standard deviation of 2 ounces.

  Computation for straight -line regression

Illustrate by computation that, for straight -line regression of Y on x, β1= 0.

  Third quartile and mean introduction

Assuming that the standard deviation and the normal shape are unchanged, to what level must the mean reduce so that 20 gallons per week is the third quartile rather than the mean?

  Calculating ho by using traditional-classical method

Compute mean x and standard deviation s of data above. Calculate Ho by using traditional/classical method.

  Computing the standard deviation for distribution

Now compute the standard deviation for this distribution.

  The ceo of the business has nothing better to do

The CEO of the business has nothing better to do wheras measured the temperatures of 26 department managers 1 to 4 times every day to get a total of 123 measurements.

  Variance-standard deviation from frequency distribution

Given the following frequency distribution, find the mean, variance, and standard deviation. Please show all of your work so I can see how to do this for the future. This one is good example of what I can do in future for real estate.

  Normally distributed population

Suppose that an IQ test was given to a large group of persons, the scores are assumed to be from a normally distributed population, that mean = 100 and s (standard deviation) = 15.

  Probability that a randomly selected student has correct ans

Further, 20 students get both questions 1 and 2 incorrect, 15 get both questions 2 and 3 incorrect, and 8 get both questions 1 and 3 incorrect, and 7 get all three questions incorrect. Find the probability that a randomly selected student: a) Gets..

  Assumptions for simple linear regression model

Provide a discussion that supports the assumption that the variance of savings increases with family income.

  Estimated regression model

The following estimated regression model was developed relating yearly income (Y in $1,000s) of 30 individuals with their age (X 1 ) and their gender (X 2 ) (0 if male and 1 if female).

  Solving questions using steps of hypothesis testing

Is your sample of MSU students significantly different from the population of MSU students in terms of the number of classes they take per semester (use alpha level .05)? To answer this question, follow all of your steps for hypothesis testing.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd