Skip to main content

The “Account Balances.xls” data set has information on the account balances of customers at a bank’s four locations. We want to test the null...

(a) I do not have a current copy of Excel. The following are instructions that should get the Anova output:


(1) Enter the data in columns A,B,C, and D.
(2) On the toolbar select Data -> Data analysis
(3) Select Anova -> single factor
(4) Enter the range A4:D23 (as it appears in your spreadsheet)
(5) Select grouped by columns
(6) Select or enter 0.05 for the alpha level
(7) Check output range and type in E2


You should get the following information:


F=2.352657462
p=0.0792776228
Factor:
df=3
SS=2551767.07
MS=850589.022
Error
df=72
SS=26031162.9
MS=361543.929
SXP=601.285231


(b) Do not reject the null hypothesis. `p > alpha ` . (.07>.05; the probability that you could have a group such as this by chance is greater than your level of confidence.)


Compare p to the alpha level. When `p <= alpha ` we reject the null hypothesis. 


(c) Our basic assumption is that the average values for each city (means) are the same. We assume that the spread of the data is the same for each city (variances.) The Anova test returns the probability that we could get samples from a group of cities that looks like the samples we got if the averages really were the same.


If that probability (p) is low  (lower than some expectation that we had before running the test) then we conclude the averages of at least two of the cities must be different (reject the null hypothesis.)

Comments

Post a Comment

Popular posts from this blog

Is there a word/phrase for "unperformant"?

As a software engineer, I need to sometimes describe a piece of code as something that lacks performance or was not written with performance in mind. Example: This kind of coding style leads to unmaintainable and unperformant code. Based on my Google searches, this isn't a real word. What is the correct way to describe this? EDIT My usage of "performance" here is in regard to speed and efficiency. For example, the better the performance of code the faster the application runs. My question and example target the negative definition, which is in reference to preventing inefficient coding practices. Answer This kind of coding style leads to unmaintainable and unperformant code. In my opinion, reads more easily as: This coding style leads to unmaintainable and poorly performing code. The key to well-written documentation and reports lies in ease of understanding. Adding poorly understood words such as performant decreases that ease. In addressing the use of such a poorly ...
Post a Comment
Read more

A man has a garden measuring 84 meters by 56 meters. He divides it into the minimum number of square plots. What is the length of the square plots?

We wish to divide this man's garden into the minimum number of square plots possible. A square has all four sides with the same length.Our garden is a rectangle, so the answer is clearly not 1 square plot. If we choose the wrong length for our squares, we may end up with missing holes or we may not be able to fit our squares inside the garden. So we have 84 meters in one direction and 56 meters in the other direction. When we start dividing the garden in square plots, we are "filling" those lengths in their respective directions. At each direction, there must be an integer number of squares (otherwise, we get holes or we leave the garden), so that all the square plots fill up the garden nicely. Thus, our job here is to find the greatest common divisor of 84 and 56. For this, we prime factor both of them: `56 = 2*2*2*7` `84 = 2*2*3*7` We can see that the prime factors and multiplicities in common are `2*2*7 = 28` . This is the desired length of the square plots. If you wi...
Post a Comment
Read more

What warning does Chuchundra issue to Rikki?

Chuchundra, the sniveling, fearful muskrat who creeps around walls because he is too terrified to go into the center of a room, meets Rikki in the middle of the night. He insults Rikki by begging him not to kill him. He then insults him by suggesting that Nag might mistake Chuchundra for Rikki. He says, "Those who kill snakes get killed by snakes."  He issues this warning to Rikki not to help keep Rikki safe but as a way of explaining why Rikki's presence gives him, Chuchundra, more reason to fear.  Chuchundra starts to tell Rikki what Chua the rat told him--but breaks it off when he realizes he might be overheard by Nag. He says, "Nag is everywhere, Rikki-Tikki." Rikki threatens to bite Chuchundra to get him to talk. Even then, Chuchundra won't overtly reveal any information. But he does say, "Can't you hear, Rikki-Tikki?" This is enough of a clue for the clever mongoose. He listens carefully and can just make out the "faintest scratch-s...
Post a Comment
Read more