They are: Income Z-score 179700 | | | 3.02257 | 200500 | | | 3.619959 | 201700 | | | 3.654424 | 202400 | | | 3.674528 | 205900 | | | 3.77505 | 322500 | | | 7.123872 | Excel functions: Income Mean: =AVERAGE(Data!G2:G411) Standard Deviation: =STDEV(Data!G2:G411) z-score calculation: =(G2-Sheet2!$B$1)/Sheet2!$B$2 or =(G2-74459.51)/34818.21 c) Age of subscribers approximates normal distribution, and according to empirical rule
Words: 922 - Pages: 4
Contents Executive Summary 2 CHAPTER-1 3 Introduction: 3 Significance of the Study: 3 Objectives of the Study: 4 Scope: 4 CHAPTER-2 5 Literature Review: 5 CHAPTER-3 7 Findings: 7 Pie Charts: 8 CHAPTER-4 11 Analysis: 11 Model Summary 11 ANOVAb 11 Coefficientsa 11 Coefficient Correlationsa 12 Correlations 12 CHAPTER-5 13 Recommendations: 13 Conclusion: 13 APPENDIX 14 Questionnaire: 14 References 16 Executive Summary To know about the consumer buying
Words: 2764 - Pages: 12
from each of the accounts analyzed. The average customer has a balance between $1500 and $2000 with twelve accounts exceeding the $2000 balance. The Cincinnati branch observed a mean or average account balance of $1281 With minimum balance being $343 and a max balance of $1913. Of the data observed the Median of the data is $1397 which more realistically shows the middle point of account balances, this is due in part to the unusually low $343 balance observed in one of the accounts. The Atlanta
Words: 406 - Pages: 2
1 3 5 5 7 8 8 8 8 8 8 9 9 9 9 9 10 10 10 10 Min: 1 Max: 10 Median: 8 + 8 = 16/2 = 8 First Quartile: Q1 = 7 + 8 = 15 = 7.5 2 2 Median of the Lower Half Thrid Quartile: Q3 = 9 + 9 = 18 = 9 2 2 Median of the Upper Half Five Number Summary: 1 – 7.5 – 8 – 9 – 10 Min – Q1 – Q2 – Q3 – Max A. 9, 8, 10, 10, 12, 6, 11, 10, 12, 8 Mean: 9+8+10+10+12+6+11+10+12+8= 96/10 = 9.6 Median: 6, 8, 8, 9, 10, 10, 10,
Words: 614 - Pages: 3
on job satisfaction in businesses. In many cases, the average calculation for the mean, median, and mode are unsatisfactory methods to determine qualitative data. However, the gender within this study is labeled with 1 and 2, and this would be considered appropriate. The mean that was calculated in this assignment was 1.275 rounded to 1.28 which demonstrated that the sample consisted of more men than women. The median was found by taking all of the numbers and putting them into numerical order and
Words: 681 - Pages: 3
HOW TO ORGANIZE DATA One way of organizing raw data or observations is through the use of frequency distribution table. One such example is a profile of cooperatives in a province which is given below: |Initial Capital, in Pesos |Number of Cooperatives | |Below 25,000 |43 | |25,000 – 49,999 |28 | |50,000 – 74,999 |17
Words: 964 - Pages: 4
distribution? 3) What is frequency curve? Explain cumulative frequency curve with example? 4) Suppose mean of a series of 5 item is30.four values are respectively, 10, 15, 30 and 35.estimate the missing 5th value of the series. ANSWER : Mean = (10+15+30+35+x)/5=30 Therefore, x=(30*50)-( 10+15+30+35) i.e x = 150-90, hence x=60 5) Calculate median of the following distribution of data. Class interval | 0-5 | 5-10 | 10-20 | 20-30 | 30-50 | 50-70 | 70-100 | frequency
Words: 1424 - Pages: 6
Mean =AVERAGE() Weighted Mean =SUMPRODUCT(weights, values) / n Where n = SUM(weights) Median =MEDIAN() Mode =MODE() Range =MAX()-MIN() Class Width =range / number of classes All Versions of Excel Excel 2010 Variance Sample: =VAR() =VAR.S() Population: =VARP() =VAR.P() Standard Deviation (SD) Sample: =STDEV() =STDEV.S() Population: =STDEVP() =STDEV.P() Or,=SQRT(variance) Or, =variance^0.5 Skewness =3*(AVERAGE() - MEDIAN()) / SD Coefficient of Variation =SD / AVERAGE()
Words: 671 - Pages: 3
is the amount of funds that are currently charged to the credit card. Credit balance is a quantitative variable which means we actually can get an exact numerical value. A histogram is a graph of frequency distribution using rectangles. Descriptive Statistics: CREDIT BALANCE($) Total Variable Count N N* CumN Percent CumPct Mean SE Mean StDev CREDIT BALANCE($) 50 50 0 50 100 100
Words: 882 - Pages: 4
extending to the left) which means that the majority of students got grades between 15 and 30 while a small number of them got low grades. This more emphasized by calculating the coefficient of skewness for this variable which is -1.02. * The Histogram is also Unimodal and the modal class is 20- which has a frequency of 101 which means that 101 students got grades from 20 to 25 with a percentage of 43.72% of the total population. (See table 2 in the Appendix). The Mode for this distribution is unique
Words: 856 - Pages: 4
