how to get descriptive statistics in excel mac

This process is very time consuming and is open for errors.

The following is an example of the type of information I got from the psych package: vars n mean sd median trimmed mad min max range skew kurtosis seġ 1 559 2.02 2.21 1 1.75 1.48 0 9 9 0.78 -0.65 0.09 To do this I used the psych package: library(psych)ĭescribe(CompanyF$NumberofRepresentatives)įrom using the package I was able to get dataframes and then go into Excel and construct the rows by hand, inputting the values that I received and omitting any information given by the psych library package that didn't correspond to what I was interested in. I have used the descriptive statistics feature in R to get the dataframe to identify the code for me. These should all correspond to company F. What I am looking to do is to have R calculate the descriptive statistics and for each one of these specific columns and export it into Excel in the following manner: Company F Average Number of Attendance Standard Deviation of Number of Attendance Min Number of Attendance Max Number of Attendance and Number of People in Attendance Average of Number of Representatives Standard Deviation of Number of Representatives Min of Number of Representatives Max Number of Representatives Total Number of Values Average Number of Presenters Standard Deviation Number of Presenters Min Number of Presenters Max Number of Presenters Total Number of Presenters Average Company Audience Standard Deviation Company Audience Min Number of Company Audience Max Number of Company Audience Total Number of Company Audienceīecause this is such a long row, I'll summarize it by saying that I am trying to find the descriptive statistics of each one of these columns. Attendance Number of representatives Number of Presenters Company Audience The following is a set of information on one given company which I'll call Company F. My goal is to identify the descriptive statistics (mean, standard deviation, min max, and the number of values) corresponding to several variables.

I have a large database of more than 85,000 values for more than 100 different companies tagged along more than 100 variables.

How to get descriptive statistics in excel mac