Verified Document

Mathematics A Spreadsheet Data Analysis B State Essay

Mathematics a) Spreadsheet Data Analysis

b) State hypotheses:

Ho: Type of soft drink and resident are independent. (null hypothesis)

Ha: Type of soft drink and resident are not independent. (alternate hypothesis)

c) Conduct chi-square test of independence at 0.05 significance level: = 0.05

d) Calculate degrees of freedom: Number of rows = 2, Number of columns = 2

Degrees of freedom (df) = (Number of rows - 1) x (Number of columns - 1) = (2-1)(2-1) = 1

e) Calculate the expected frequencies from actual data:

f) Calculate the chi-square statistic using both actual and expected frequency tables:

In excel, the cursor was placed in cell M17 and the formula of chi test typed as:

=CHITEST (actual frequency range, expected frequency range)

=CHITEST (L4:M5, L13:M14), as shown in the formula bar above

The result gives, the calculated chi-square...

If p OR ?2, we reject the null hypothesis and conclude that at the 0.05 significance level, there is a relationship between the row variables and column variables. Since p = 1.2203 x 10-10 < ? = 0.05 (OR ?2 = 3.84 > ? = 0.05) we conclude that there is a relationship between type of soft drink and resident response.
2. a) Forbes Data

Based on the statistical report and values highlighted, we see that there is a significant relationship between:

i) sales and market value, ii) sales and cash flow, iii) cash flow and market value

The rest…

Cite this Document:
Copy Bibliography Citation

Related Documents

Score Stats a Statistical Analysis
Words: 840 Length: 3 Document Type: Research Paper

Descriptive Statistics Test subjects were 53.3% male and 46.7% female, as shown in the bar graph on the accompanying Excel spreadsheet. The test population has a mean age of 15.9 years (standard deviation=0.80). These descriptive statistics validate the randomized population of the research study, as the population is almost evenly split between males and females and the mean age is also very close to the median age (16) of the study's

Spotlighting Samplings 4 Qualitative Research Choices 6
Words: 16532 Length: 60 Document Type: Research Paper

Spotlighting Samplings 4 Qualitative Research Research Choices 6 the Phenomenology Method The Ethnography Method DEPTH Four Qualitative Approach Comparison Strengths and Critiques of Case Studies "A research design indicates the full research process from conceptualization of the research problem, generation of data, analysis and interpretation of findings, and dissemination of results" (Magilvy & Thomas, 2009, What and Why… Section, ¶ 4). The Question of Interest What type of research design should the researcher use? To answer the study's critical research

Scheduling Software for a University's
Words: 11316 Length: 45 Document Type: Capstone Project

CELCAT, though, is just one of dozens of vendors competing in the class scheduling software industry as well as many open sources options that are free of charge, and the thousands of colleges and universities that have undertaken the selection process have done so largely without the benefit of a set of best practices that can be used for this purpose. As a result, it is reasonable to suggest that

Physical Education and Computer Technology
Words: 11589 Length: 40 Document Type: Term Paper

Computers Are an Underutilized Resource for High School Physical Education Teachers Computers have become an integral part of the high school learning environment, beginning in the early 1990s. They provide a vast variety of resources to help enhance student education through presentation of material in a variety of media and act as an enhancement to teacher lessons. They can sometimes free teachers from routine tasks, allowing them to bring greater depth

Probability Provides a Measurable and Quantifiable Indication
Words: 1056 Length: 3 Document Type: Discussion Chapter

Probability provides a measurable and quantifiable indication of how likely a particular outcome is for an event or experiment. It is expressed as a numeric value between zero and one (inclusive), where an impossible event has a probability of zero and a certain event has a probability of one. Probability is conventionally written using the symbol P, and may be expressed as a percentage by multiplying P. By 100. The problem

Soft Systems Techniques in the Preparation of
Words: 20187 Length: 73 Document Type: Dissertation

Soft Systems Techniques in the Preparation of Information Technology as a Systems Manager Company Systems Consulting process and model Systems approach, client relationships Company Culture Client defenses, attachments to existing systems Interaction with the company culture in order to facilitate change System and Culture working together Dependancy issues Lewin Company Systems Consulting process and model Systems approach, client relationships Company Culture Client defenses, attachments to existing systems Interaction with the company culture in order to facilitate change System and Culture working together Dependency issues Lewin's model of

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now