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

etymology - Origin of the greeting "Sweet dreams".

Does anybody know the etymology of the phrase "sweet dreams"? I tried googling but did not find anything satisfying. Is this a relatively new phrase of the modern world or has this been in use for some time? I think it's the latter one. Answer The OED has the interjection as "a farewell to someone going to bed" from the 20th century: 1908 Sears Roebuck Catal. 198/1 Tenor Solos..Good Bye, Sweet Dreams, Good Bye. But it goes back until at least the 19th and possibly 18th centuries. John Wolcot, writing under the pseudonym of Peter Pindar, used it in his poem "Orson and Ellen; A Legendary Tale" published in 1801: Also from 1801 in The infernal Quixote (Page 287) by Charles Lucas: In the March 1776 of The Universal Magazine was published "The Serenade. A Pastoral Tale. From the German of Gesner" , where the shepherd Daphnis watches over his beloved as she sleeps and sings: The same tale appears in 1776's as Idyl XI, " Daphnis ...
Post a Comment
Read more

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

What are the similarities between the relationships of the characters in The Outsiders and Romeo and Juliet?

At first glance, it might appear as if the characters in  The Outsiders  by S. E. Hinton and  Romeo and Juliet  by William Shakespeare do not have much in common; however, when one isolates the core of the conflicts, it becomes clear that the relationships in both stories are rooted in rivalry and secrecy.  In both  The Outsiders  and  Romeo and Juliet , an overarching theme is rivalry. While   socioeconomic status separates the greasers from the Socs in The Outsiders , last names separates the Montagues from the Capulets, who appear to be relatively equal in terms of socioeconomic status. Due to these rivalries, there are instances of deadly interactions in both stories. In  The Outsiders , Johnny kills Bob (whether his actions were justified or not is debatable). In  Romeo and Juliet , Romeo kills Tybalt and Paris, and Tybalt kills Mercutio. These deaths have profound effects on the main characters. In Ponyboy's case, the Johnny's death and other events in the novel inspire h...
Post a Comment
Read more