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

Is 'efficate' a word in English?

I routinely hear the word "efficate" being used. For example, "The most powerful way to efficate a change in the system is to participate." I do not find entries for this word in common English dictionaries, but I do not have an unabridged dictionary. I have checked the OED (I'm not sure if it is considered unabridged), and it has no entry for "efficate". It does have an entry for "efficiate", which is used in the same way. Wordnik has an entry for "efficate" with over 1800 hits, thus providing some evidence for the frequency of use. I personally like the word and find the meaning very clear and obvious when others use it. If it's not currently an "officially documented" word, perhaps its continued use will result in it being better documented.
Post a Comment
Read more