​Descriptive Statistics-Excel

User Generated

Nhfgenvy

Mathematics

Description

Descriptive Statistics Identify a research problem different from the previous research problems that uses two different sets of the same type of data. You may use any business subject. Some examples: Sales from two different months or years. GPA's of men and women. Number of two different shelf items sold (Coke & Pepsi) by month over a year. Home sales prices in different suburbs, cities, counties or states. You wish to determine if there is a significant difference between the means of the data sets. Select data that have absolute zero measurements (Ratio data). You may use recorded data or made up data. The n sample size should be at least 10 in each set, but not more than 29. Prepare a paper describing the research problem, research purpose and one research question. Define the variable. Discuss the type of data and determine the level of measurement. List the data. List alpha, the null and alternative hypothesis, and give a brief back ground. Using either Megastats or Analysis ToolPak do descriptive statistics on the data and do data analysis describing the data. Do runs plot graphs. Interpret the Goodness of Fit (GOF) p-value to decide if the data is parametric (normal) or nonparametric. Conclude. Use the sample I3 Descriptive Statistics as a guide. This paper should be between 700-1000 words. Post as an Individual Assignment. Title the document file "Descriptive Statistics I3"

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey! Kindly find the attached answer and in case of any issue, let me know. Thank you and all the best

Running head: DESCRIPTIVE STATISTICS

1

Descriptive statistics
Name
Institution
Date

DESCRIPTIVE STATISTICS

2
I. INTRODUCTION
Research Problem

Male students graduating from high schools may have a higher GPA compared to the
female students. This negatively affects the morale of the female students and may make them be
on the receiving head in the search for good college admissions as well as job equality.
Purpose of the Study
To investigate if there is a significant difference between the GPAs of male and female
students graduating from high school and report to the finding to the university management.
Research Question
Is there a significant difference between the GPAs of male students and GPAs of female
students graduating from high school?
Null and Alternative Hypothesis
Null Hypothesis:
Ho: There is no significant difference between the GPA of male and female students
Ho: μ1 = μ2.
Alternative Hypothesis:
H1: There is a significant difference between the GPA of male and female students
H1: μ1 ≠ μ2.
Alpha
The alpha significant level in this study is 0.05 as recommended by the university
management.
Variable Definitions

DESCRIPTIVE STATISTICS

3

A sample of 27 male students and 27 female students has been randomly selected and their
GPAs recorded for analysis. The data is grouped...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags