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

  Obstacles in improving quality of care

Identify the factors that will be required for future change in the health care industry pertaining to quality improvement, patient safety, and risk management. What are the obstacles in improving quality of care?

  Questiona workplace exposure limits such as tlvs or oels

questiona workplace exposure limits such as tlvs or oels are hygiene standards devised to set safe levels of hazardous

  Conflict perspective and the analysis of culture

Conflict Perspective and the Analysis of Culture

  What was the long nineteenth century

what was the "long nineteenth century" in Europe between the 1780s and 1919? How and when did various European countries undergo these transformations?

  Effects on society from 1500-1850

Compare North American racial ideologies to those of Latin America and their effects on society from 1500-1850.

  How do you explain reason and how does it affect the

how do you define reason and how does it affect your thinking?nbsp how do thought forms - natural sciences biology

  Concepts in management and organisational behaviour

You are to analyse the case study by identifying important issues and analysing them using the models, theories and concepts in Management and Organisational Behaviour.

  Environmental components of school readiness

Reflect on the recent trends in understanding environmental components of school readiness. Based on your prior knowledge, research and/or own experiences, which one trend do you feel is most critical for supporting school readiness and give at l..

  Visual information processing

Describe visual information processing. (Make sure to explain the structures and the specific processes.) Explain two conditions that impair visual information processing.

  Our judicial system is founded on adversarial philosophy

our judicial system is founded on adversarial philosophy,so what are the pros and cons of this system from a christian worldview?

  Difference between qualitative and quantitative research

make a report about the difference between qualitative and quantitative research methods related to the essay provided above

  Examples of this kind of sculpture

Michelangelo's Awakening Slave and the Olmec Massive Stone Head are both good examples of this kind of sculpture

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: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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