StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Descriptive spreadsheet in Excel including graphs - Statistics Project Example

Cite this document
Summary
The lowest number of employees in an organization was 15 while the highest number was 38. The average number of employees was 26.8 and this varied within a plus or minus 7.35. At least five of the…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER93.3% of users find it useful
Descriptive statistics spreadsheet in Excel including graphs
Read Text Preview

Extract of sample "Descriptive spreadsheet in Excel including graphs"

Descriptive Statistics QNT/561 Definitions Central Tendency: Mean = average value of data in a set Mode = The value that appears most in a data set. Dispersion: Standard deviation = A measure of variation. Measures average variation of data points from mean of the data set Range = the difference between the largest and smallest values in a set of dataConfidence Interval: (data must be normal) The interval within which the mean is expected to fall at a given level of significance. Normal or significantly skewed data:Skewedness valueData is normal if the value is zero or close to zeroData is skewed if the value is significantly different from zeroDescriptive StatisticsNumber of employeesCentral Tendency: Mean = 26.

8Dispersion:Standard deviation = 7.35Count:10Min/Max:15 and 38Confidence Interval:22.24 to 31.36See the descriptive statistics in Appendix B, scatter plot is in Appendix C, and histogram in Appendix D. Crime rate Distribution is normally distributedCentral Tendency: Mean = 2.77Dispersion:Standard deviation= 0.88Count:10Min/Max:1.35 and 4.15Confidence Interval:2.22 to 3.32See the descriptive statistics in Appendix B, scatter plot is in Appendix C, and histogram in Appendix F. Education LevelThirteen percent of the subjects have no high school degree while 44% have high school degree.

Forty three percent have a college or college graduate degree. See the bar chart in Appendix D. Descriptive Statistics Interpretation Interpretation Number of employees Ten organizations were used for the study and the data was normally distributed. The lowest number of employees in an organization was 15 while the highest number was 38. The average number of employees was 26.8 and this varied within a plus or minus 7.35. At least five of the entities had 27 or more employees. There is 95% confidence that the number of employees average is between 22.24 and 31.36.

Crime rate The data consisted of ten points and was normally distributed. The lowest reported crime rate was 1.35 and the highest reported rate was 4.15. average crime rate was 2.77 and this varied with a plus or minus 0.88. Five or more of the organizations realized a crime rate of at least 2.78 and there is a 95% confidence that the mean crime rate is between 2.22 and 3.32. APPENDIX ARaw data# of Employees HiredCrime Rate%151.35181.63242.33222.41252.63292.93303.41323.26353.63384.15APPENDIX BDescriptive Statistics for number of employees and crime rateStatisticsnumber of employeescrime rateMean26.82.773Standard Error2.

3228335190.27844828Median272.78Mode#N/A#N/AStandard Deviation7.3454445440.880530774Sample Variance53.955555560.775334444Kurtosis-0.807925709-0.628885642Skewness-0.113037817-0.181915294Range232.8Minimum151.35Maximum384.15Sum26827.73Count1010APPENDIX CScatter plot for number of employees versus crime rate APPENDIX DHistogram for number of employeesAPPENDIX EHistogram for crime rate

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Descriptive statistics spreadsheet in Excel including graphs Project”, n.d.)
Retrieved from https://studentshare.org/statistics/1696998-descriptive-statistics-spreadsheet-in-excel-including-graphs
(Descriptive Statistics Spreadsheet in Excel Including Graphs Project)
https://studentshare.org/statistics/1696998-descriptive-statistics-spreadsheet-in-excel-including-graphs.
“Descriptive Statistics Spreadsheet in Excel Including Graphs Project”, n.d. https://studentshare.org/statistics/1696998-descriptive-statistics-spreadsheet-in-excel-including-graphs.
  • Cited: 0 times

CHECK THESE SAMPLES OF Descriptive statistics spreadsheet in Excel including graphs

Globalization: Research Methodology

The dissertation seeks to answer the questions: What are the major challenges that non-English speaking organisations face when communicating in English?... Is there a statistically significant relationship between diverse cultures and workplace conflicts within multicultural organisations?... … The paper operates mainly based on research questions which can be stated as follows: How do multicultural workforces communicate effectively within a non-English speaking organization both verbally and nonverbally?...
21 Pages (5250 words) Essay

Intern as Revenue Manager Assistant from March 2009 to August 2009 At The Grand City Hotel, Berlin

 This essay discusses the result work intern as revenue manager assistant.... Having worked as an intern in the Grand City Hotel for six months, the writer has got a comprehensive insight into the set of skills and competencies required by an individual to perform his/her duties successfully....
12 Pages (3000 words) Coursework

Barriers to Meaningful Instruction for English Learners

In the paper “Barriers to Meaningful Instruction for English Learners,” the author discusses the need to develop an environment that facilitates communication before the problem arises since different cultures have varying degrees of social acceptance and contradicting opinions from different people....
7 Pages (1750 words) Research Proposal

Bsiness statistic assignment

5 Pages (1250 words) Assignment

Implementing a Kiosk at POS

The main theme behind introducing the concept of Kiosk technology was to initiate the theme of 'self service'; in an attractive, well organized way that could spur the sales and customer satisfaction ratio. ... ... iosk point-of-sale systems provide 24 x 7 availability to the customers where they can make transactions in an easy, user-friendly manner (Silicon Landmark, n....
9 Pages (2250 words) Essay

ENGINEERING HYDROLOGY Assignment

You may need you use the Pivot Table feature in excel to summarise your monthly statisticsFor the flood frequency analysis, you will need to obtain the annual maximum series (AMS) for these two stations from the HiFlows website:http://www.... In this practical you are to (i) analyse, compare and contrast recorded flow data from two catchments and (ii) use a range of other techniques to characterise the flood hydrology for a range of design specifications....
4 Pages (1000 words) Assignment

Water Shortage In New Zealand

Hence in order to enable ease of data recording, interpretation, and analysis, the decision to use and design the excel spreadsheet was made.... This research report contained valuable information which included statistics (numerical data) as well as textual information such as information about the websites visited for accessing the data on Territorial Authorities in New Zealand and their various policies and approaches with regard to water supply in the country....
23 Pages (5750 words) Essay

Using Excel and SPS in a Major Research Paper

The following list of comments will explain my meaning more clearly:in excel, descriptives, statistical requirements, and frequency data can be managed with some of the program's standard functions.... t is sometimes difficult to find full sets of statistical tests in excel, and working with these tests can be challenging.... his package extends the capabilities of Excel 2007 by including specialized tools in the package.... The author of the paper examines excel and SPS packages used for Major Research Paper....
8 Pages (2000 words) Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us