Analyzing the Data Set Using Descriptive Statistics

Analyzing the Data Set Using Descriptive Statistics

Now that you have your unique survey data in Excel, you can perform descriptive statistics with the tools about which we learned at the beginning of the course. You may choose how you wish to analyze the data, but your work should include the following at a minimum:

Questions 1, 2, 3, and 4 (Binomial Questions)

Each question should have the following elements:

• Sample Proportion of each response.

• Sample Size.

• Bar Chart (Column Chart) or Pie Chart.

Questions 5 and 6 (Continuous Questions)

Each question should have the following elements:

• Sample Mean.

• Sample Median.

• Sample Mode.

• Sample Standard Deviation.

• Sample Range.

• Sample Minimum and Maximum.

• Histogram.

Next, explore your data a bit further. What are two interesting findings from your survey responses? Investigate responses for selected variables based on responses to binomial questions. For example, if the answer to question 1 was Male or Female and to question 8 was Annual Income, you might examine average annual income for Males only and Females only and compare these results. Present your interesting findings as both a table and an appropriate graph or chart.

Results note: Because the survey data generation is done without context, you will have to put aside any preconceived notions about how your data should look. Your task is to analyze, interpret, and communicate the unique results.

Technology note: You will need to sort or rearrange your original data file to accomplish some of these tasks. Be sure you keep a copy of your original data file e-mail attachment as a backup.


1. Analyze your data according to the assignment description.

2. Format your findings in an Excel spreadsheet with appropriate and easy-to-read labels.

3. Submit your spreadsheet to your instructor in the Analyzing the Data Set Using Descriptive Statistics assignment area.

Compétences : Excel

en voir plus : to the maximum, set bit in c, set a bit in c, sample graph data, how to set a bit, how to graph data, graph using c, graph the data, graph sample data, graph assignment, data in a graph, 8 bit technology, descriptive statistics survey results, descriptive statistics powerpoint using spss, interpret descriptive statistics wage data, descriptive statistics data interpretation sales, hotel booking using xml data, using excel data google finance vba, set data feeds, benifits teachers using excel data, identify possibilities given set data excel lotto, using struts data oracle database jsp struts

Concernant l'employeur :
( 1 commentaire ) Warrenton, United States

Nº du projet : #8462628

2 freelance font une offre moyenne de $89 pour ce travail


As discussed, i guess I will give the descriptive statistics with graphs. Please attach the data file.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(62 Commentaires)

I am an accurate and reliable business/Accounting/finance Analyst. I am a proficient business expert with over eight years writing experience. I have experience in Business plan writing, payroll, bank reconciliation, j Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(9 Commentaires)