User Account

All Pages

Calculate the averages for pre-course and post-course survey

Assignment Help Other Subject
Reference no: EM131301932

Create a graph to visualize any differences between your Pre- and Post-Course Survey data.

An Excel Tutorial provides detailed instructions.

Instructions

Calculate the averages for pre-course and post-course surveys

1. Open the excel file with your survey results for pre-course and post-course surveys. You will only find four questions. You need to analyze these four questions.

2. Create a column named Average.

3. Click a cell to the right of the numbers for which you want to find the average. In this example, the cell is clicked on is G2.

4. The range C2:F2 in this example contains the results of pre-course survey result, typing in =AVERAGE(C2:F2) returns the average of these numbers.

5. Repeat the above steps for post-course result.

6. Ctrl-click on Surveys and Average to select these columns.

7. In menu bar, click on INSERT button, Click on the arrow next to the type of chart you would like to make. If you want a traditional bar graph, you will choose "Bar." If you want a vertical graph, click the arrow next to "Column."

8. Save the file.

Attachment:- excel graph tutorial.rar

Verified Expert

This assignment requires preparing a graphical representation for visual aid in order to ascertain any difference in responses by the respondents prior to and post the course on given four parameters. The visual representation has been carried out based on the average of the responses across four parameters by all respondents in pre-course as well as post-course stage.

Reference no: EM131301932

Questions Cloud

What is the after tax salvage at the terminal year : Build a capital budgeting model to answer the following questions: What is the initial outlay in year 0? What is the after tax salvage at the terminal year? Calculate NPV, IRR, and PI for the project
Calculate the cost of matts condo during the first year : Calculate the cost of Matt's condo during the first year if he currently has the $5,000 down payment invested in an account earning 5% interest.
Discuss about the history of amerivan politics : Discuss about the history of Amerivan politics. The American West and Age of Enterprise and Industrialism, Politics, and Progressivism at the turn of the Twenty-First CenturyView Full Description
Explain ways in which richard branson is likely to motivate : Determine two key ways in which Richard Branson is likely to motivate employees in order to achieve his goals for the Virginia Group. Indicate whether or not his approach is likely to work in a different organizational setting.
Calculate the averages for pre-course and post-course survey : Calculate the averages for pre-course and post-course surveys - Create a graph to visualize any differences between your Pre- and Post-Course Survey data.
Calculate the cost of matts condo during the first year : Calculate the cost of Matt's condo during the first year if he currently has the $5,000 down payment invested in an account earning 5% interest.
Major league baseball game : There were 551 tickets purchased for a major league baseball game. The lower box tickets cost $12.50 and the upper reserved tickets cost $8.00 The total amount of money spent was $5789.50 How many of each kind of ticket were purchased?
Manager charge to maximize revenue : The manager of a 100-unit apartment complex knows from experience that all units will be occupied if the rent is $500 per month. A market survey suggests that, on average, one additional unit will remain vacant for each $10 increase in rent. What ..
What would their annual savings be if they refinance : Doug and Lynn bought their home three years ago. - What would their annual savings be if they refinance? They are in a 15% marginal tax rate bracket.

Reviews

len1301932

12/5/2016 7:56:54 AM

hello there, could you help me with this ? this my professor email " If you completed your Pre-Course and Post-course Surveys, you have received an email containing your responses for four items from those two surveys in an Excel file. Your assignment is to create a graph to visualize any differences between your Pre- and Post-Course Survey data. An Excel Tutorial provides detailed instructions. You have three attempts to successfully complete this assignment " I have attached all document required

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd