Data Analysis In Excel

Document Type:Excel Assignment

Subject Area:Nursing

Document 1

Some of the functions of the Excel data sheet include MIN which enables the identification of the minimum variable available in the data set, MAX which provides the maximum variable, MAX-MIN provides a range between the minimum and the maximum variables in the data set. COUNT function on the excel sheet counts the variables, AVERAGE provides a mean of the data set and STDEV/P enables calculation of standard deviation (Statistics & Risk Management, 2018). Using the Descriptive Statistics tool on existing data variables in Excel provides you with 16 different descriptive statistics without entering functions into the worksheet. To utilize the data analysis function of the Excel, one has to select the data tab which is located on the data analysis link in the analyse group, the spread sheet offers a range of selections for the data analysis work sheet which once the options which auto populate after selecting the data analysis tool indicate the spreadsheet can then be used for the data analysis.

Sign up to view the full document!

My plans for learning about data analysis using Excel is to keep on practicing using the spreadsheet on regular basis for the data analysis. net/untdeveloper/RM/Stats_Module_6_rev/Stats_Module_6_rev5. html.

Sign up to view the full document!

From $10 to earn access

Only on Studyloop

Original template

Downloadable