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

Albert Einstein, a Famously Mediocre Student, Once
Words: 6706 Length: 20 Document Type: Term Paper

Albert Einstein, a famously mediocre student, once commented that "It is little short of a miracle that modern methods of instruction have not completely strangled the holy curiosity of inquiry." Many educational theorists and gifted teachers have taken this to heart, and endeavored to create learning environments that reflect innovations that are both intuitive and ingenious. Unfortunately, we often see these same innovations stifled at the High School level. Whereas

Teacher Attitudes and Perceptions About Curriculum Innovation in...
Words: 22121 Length: 76 Document Type: Term Paper

Self-Efficacy: A Definition Social Cognitive Theory Triangulation Data analysis Teacher Self-Efficacy Problems for the researcher Data Analysis and Related Literature review. Baseline Group Gender Deviation Age Deviation Comparison of data with other literature in the field. Everyday Integration Efficacy, Self-esteem, Confidence and Experience Barriers to use Integration paradigm. Co-oping and Project design. Organizational Climate Teacher Integration Education. Meta-evaluation of data and related literature. Data Analysis and Comparison Recommendation for Further Research Data Review Report Teacher efficacy in the classroom is facilitated by a number of different factors for different professions. However,

Chinese As a Foreign Language
Words: 4930 Length: 17 Document Type: Thesis

The program primarily supports the local Chinese communities to maintain younger generation's heritage background, and spreading Chinese culture in the U.S. The classes are normally held two to three hours on weekends with Chinese language lessons and other traditional cultural and art activities. Most students have high levels of oral proficiency in Chinese, but needed to enhance skills in literacy. Chinese heritage schools are mainly supported by two groups:

NBA Players Height Vs. Points Per Game Average
Words: 614 Length: 2 Document Type: Term Paper

NBA Stats Mean is determined by adding all data points in a single column together and dividing by the number of data points (in this case, 100). The Excel "AVERAGE" function was used to save time on arithmetic, but performs exactly this calculation. Median simply takes the central value in a data set when the set is arranged in order of numerical value (or the mean of the two central data points

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