Finance Statistic in Excel. Mean Mod Etc
Contents Introduction 3 TASK 1 4 TASK 2 – Graphs and calculations 5 Mean, standard deviation, mode, etc. 6 Mean and Standard Deviation of a Frequency distribution 6 Work satisfaction 6 Working condition 13 Effective management 19 Stress in Workplace 25 TASK 3 – t-test 31 TASK 4 – Correlation and Regression 33 TASK 5 – Summary 35 BIBLIOGRAPHY 36 APPENDIX 1. 37 300 random numbers 37 30 selected random numbers from random array. 38 APPENDIX 2. 39 Sample of 30 records used 39
Introduction
The total set of potential observations is named a population and the set of actual observation is hand is named a sample from this population. (Koch & Link, 2002)
The sample of data analysis in this assignment is concerned with level of satisfaction of 310 employees from Operations and Administration departments in London and Birmingham.
During the survey, answers was measured from 1 (low satisfaction) to 10 (high satisfaction).
In this assignment, for analysis was randomly taken survey results of 30 employees.
TASK 1
Random sampling is how a sample is drawn from a population, and it is related to the external validity of a study 's result. (Dattalo, 2010)
Random number is spontaneous number which can be found by different methods. As an example of random numbers can be roulette in casino when you never can predict or calculate it. In statistics, data often chosen randomly from selected range.
In Microsoft Office Excel it can be found by simple function random() or if function randbetween(min number,max number) which allow select random number from selected range.
In this assignment, the data was sampled using Microsoft Office Excel and function randbetween(1,310). This function gave us a random number from range 1 to 310.
After this we hold right bottom corner of cell and drag it unless it not reach size 10 by 30 cells.
After when 300 random numbers from range 1 to 310 was ready, we chose and highlight 30 numbers for our
Introduction
The total set of potential observations is named a population and the set of actual observation is hand is named a sample from this population. (Koch & Link, 2002)
The sample of data analysis in this assignment is concerned with level of satisfaction of 310 employees from Operations and Administration departments in London and Birmingham.
During the survey, answers was measured from 1 (low satisfaction) to 10 (high satisfaction).
In this assignment, for analysis was randomly taken survey results of 30 employees.
TASK 1
Random sampling is how a sample is drawn from a population, and it is related to the external validity of a study 's result. (Dattalo, 2010)
Random number is spontaneous number which can be found by different methods. As an example of random numbers can be roulette in casino when you never can predict or calculate it. In statistics, data often chosen randomly from selected range.
In Microsoft Office Excel it can be found by simple function random() or if function randbetween(min number,max number) which allow select random number from selected range.
In this assignment, the data was sampled using Microsoft Office Excel and function randbetween(1,310). This function gave us a random number from range 1 to 310.
After this we hold right bottom corner of cell and drag it unless it not reach size 10 by 30 cells.
After when 300 random numbers from range 1 to 310 was ready, we chose and highlight 30 numbers for our
Bibliography: Dattalo, P., 2010. Strategies to Approximate Random Sampling and Assignment. New York: Oxford University Press Inc. Harmon, M., 2011. t-Tests in Excel - The Excel Statistical Master, London: Mark Harmon. Koch, G. S. & Link, R. F., 2002. Statistical Analysis of Geological Data. Devon: David & Charles. Miles, J. & Shevlin, M., 2004. Applying Regression and Correlation: A Guide for Students and Researchers. London: SAGE Publications Ltd.. Nelson, S. L., 2007. Excel 2007 Data Analysis For Dummies. Hoboken: Wiley Publishing Inc. APPENDIX 1. 300 random numbers 30 selected random numbers from random array. APPENDIX 2. Sample of 30 records used