descriptive statistics excel

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”

Solution:

15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!