logo

Data Analysis And Overview Assignment

   

Added on  2022-08-27

5 Pages579 Words18 Views
Running head: DATA ANALYSIS 1
Data Analysis
Student Name
Professor’s Name
University Name
Date

DATA ANALYSIS 2
Data Analysis
Solutions
a. The frequency distribution table created in excel is illustrated in the figure below:
The histogram created from the frequency distribution table above is shown below.
b. The mean test score can be calculated in excel by inserting the following formula in an
appropriate cell.
𝑚𝑒𝑎𝑛 = 𝑎𝑣𝑒𝑟𝑎𝑔𝑒 (𝑏𝑖𝑛 𝑟𝑎𝑛𝑔𝑒)
The mean is 61.83 as shown below.Frequency Distribution
Class Midpoint Upper limit Frequency Cumulative Freuency Relative Freuency
1≤x≤10 5.5 10 2 2 0.02
11≤x≤20 15.5 20 1 3 0.01
21≤x≤30 25.5 30 3 6 0.03
31≤x≤40 35.5 40 5 11 0.05
41≤x≤50 45.5 50 12 23 0.12
51≤x≤60 55.5 60 20 43 0.2
61≤x≤70 65.5 70 23 66 0.23
71≤x≤80 75.5 80 16 82 0.16
81≤x≤90 85.5 90 10 92 0.1
91≤x≤100 95.5 100 8 100 0.08
Sum 100 1Summary Satistics
Min 1.50
Max 97.20
Average 61.83

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Data Analysis Assesment Project
|5
|369
|20

Statistics Study Material with Solved Assignments and Essays - Desklib
|8
|642
|52

QUANTITATIVE METHODS.
|7
|321
|328

Questions on the Statistics 2022
|5
|494
|42

Statistics for Business
|7
|1613
|278

Analysis of Machine Motors' New Vehicle Advertising Strategy
|7
|938
|67