University Math 1070: Spreadsheet Software Project Analysis

This document presents a solution to a Math 1070 spreadsheet software project, covering descriptive statistics, pie charts, bar graphs, normal distribution, and correlation analysis. The solution includes calculations of mean, median, standard deviation, and range using Excel. It analyzes the relationship between means and standard deviations, creates pie charts and bar graphs for data visualization, determines the value of X in a normal distribution problem, and examines correlation coefficients and least squares regression. A bonus question involves a t-test comparing male and female body measurements, addressing outliers and hypothesis testing. The project demonstrates the application of statistical concepts and spreadsheet software for data analysis and interpretation.

BASIC PRACTICE OF STATISTICS
STUDENT ID:
[Pick the date]

Exercise 1: Descriptive Statistics
The requisite steps stated in part A, B,C have been enacted in the attached spreadsheet. The
result obtained from this is summarised as the screenshot below.
Using the various descriptive statistics functions available in Excel, the mean, median,
standard deviation and range for the various follows have been estimated as follows.
The relationship between the three means (i.e. μ, μ1 and μ2) can be described as follows.
μ = μ1 - μ2
It needs to be analysed if the above relationship extends to standard deviation as well or not.
σ = 3.1 , σ1 = 3.1 and σ2= 2.5
From the above values, it is evident that the relationship observed in mean is not observed
with regards to standard deviation.

Exercise 2: Pie Charts and Bar Graphs
The requisite steps have been followed and pie chart & bar chart for illustration of the given
data has been created using Excel.
Exercise 3: The Normal Distribution
A) 0.788
B) Value of X is 6.698
C) Taylor must be 65.84 cm tall at the age of 17% so that she is taller than 73% of the girls of
her age.
Exercise 4: Correlation and Least Squares Regression
I expect the correlation coefficient to be zero since two series of numbers have bee
randomly created and hence they should have not any linear relationship between
them. However, this is not true since the actual correlation coefficient is -0.282. This
weak correlation between the two randomly selected variables may be on account of
the small range i.e. both the variables needed values between 0 and 10. As a result, some
extent of correlation can potentially arise.
Bonus Question
Based on the given values for the male and females, there has been detection of outlier in the
female values. As a result, the 65th observation where the female value is 100.8 has been
deleted before performing the t test.
The appropriate output of the t test is shown below.

Null hypothesis: μM = μF
Alternative hypothesis: μM ≠ μF
Level of significance = 0.05 or 5%
The two tail p value is 0.0252 which is lower than 0.05 (Significance Level).
As a result, null hypothesis would be rejected and alternative hypothesis would be accepted.
This implies that average body measurements between males and females display statistically
significant difference.