In excel compute the sample average and the standard, Ask an Expert

Statistics

The Department of Economic and Community Development (DECD) reported that in 2005 the average number of new jobs created per county was 450. The department also provided the following information regarding a sample of 5 counties in 2006.

County New Jobs Created In 2006
Bradley 410
Rhea 480
Marion 407
Grundy 428
Sequatchie 400

In Excel compute the sample average and the standard deviation for 2006.

We want to determine whether there has been a significant decrease in the average number of jobs created.

In Excel compute and report the test statistic. (z or t-score, just report the numeric value)

View complete question

Statistics and Probability, Statistics

Category:- Statistics and Probability
Reference No.:- M9116678

Have any Question?Write your Review or question?

Related Questions in Statistics and Probability

1 coal is carried from a mine in west virginia to a power

1. Coal is carried from a mine in West Virginia to a power plant in New York in hopper cars on a long train. The automatic hopper car loader is set to put 89 tons of coal into each car. The actual weights of coal loaded ...

Consider the study of two insect populations at two

Consider the study of two insect populations at two experimental stations. At station A, the egg hatch rate (computed from a set of 100 eggs at a time) is known to follow approximately a normal distribution with mean 62% ...

Doctoral assistant ships of phd students 50 have paid

Doctoral assistant ships of Ph.D students 50% have paid assistant ships. a random sample of n=200 students is chosen.. based on this sample and using the properties of the binomial distribution, what is the approximate s ...

What is the future value of a 1000 annuity payment over 4

What is the future value of a $1,000 annuity payment over 4 years if the interest rates are 8 percent?

For planning purposes truss manufacturers must try to

For planning purposes, truss manufacturers must try to predict the number of hurricanes that will hit the eastern seaboard of the United States in any given year. If this area is hit with an average of 6 hurricanes per y ...

A lot contains 15 items and 6 are defective if two items

A lot contains 15 items and 6 are defective. If two items are drawn at random from the lot, without replacement, what is the probability there is exactly one non-defective? (Hint: You have to use both Multiplication and ...

We perform a statistical test to examine if the mean

We perform a statistical test to examine if the mean lifetime of lab mice increases when given vitamin B12 compared to a placebo. Which of the following is a Type I error? Conclude that Vitamin B12 increases the mean lif ...

Jen and barry get sued by ben amp jerrys for trademark

Jen and Barry get sued by "Ben & Jerry's" for trademark infringement. Jen and Barry lose, and they need a LOT of money. They decide to play Tennetucky's "Mega-6" lottery. They'll win the jackpot if they correctly choose ...

Tossing a fair coin three times whats the probability that

Tossing a fair coin three times, what's the probability that at least one head will occur?

According to the center for disease control the mean total

According to the center for Disease Control, the mean total cholesterol for men between the ages of 20-29 is 180 milligrams per deciliter with a standard deviation of 36.2. A healthy total cholesterol level is less than ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Statistics and Probability Expert