Types and purposes of graphic representations
18. What is a graphic representation?
A graphic representation is a illustrative diagram that shows interdependencies between variables.
19. List seven different types of graphic representations.
Column charts, area charts, pie charts, bar charts, line charts, bubble charts and scatter diagrams
20. Describe when each of these seven graphic representations would best be used.
Column charts – to show us how the data may change over time or show us the difference between two items.
Area charts – to point out the amount of transformation over time and to highlight the entire value of a trend
Pie charts – to show proportional relationships and compare parts of a whole at a given time
Bar charts –
…show more content…
What is the purpose of a condition formula?
To assess whether the circumstances are true or false and make reasonable evaluations between expressions.
24. What is the purpose of a look up formula?
To gain a value from a table (in a range) by searching up another value.
25. What is the difference between a function and a formula?
Functions are formulas that are already set that complete calculations by using given values ( called arguments) in a specific order. Functions can be used to achieve simple or hard calculations.
26. What is the advantage of sorting data?
Sorting your data in a specific way helps you find the data you want much easier.
27. What is the advantage of filtering data?
The advantage of filtering the data, is that it breaks down your information so you can get to the main bit of information quicker.
28. Provide an example of when a person may use one of the mathematical functions of a spreadsheet.
A person may use a spreadsheet to keep track of the kilometres he travelled to work for taxation purposes.
29. Provide an example of when a person may use one of the financial functions of a spreadsheet.
A person might use a spreadsheet for financial functions in case he need to prepare a quote for a customer.
30. Provide an example of when a person may use one of the statistical functions of a spreadsheet.
A person might use a spreadsheet for statistical functions to find out how many students study a VCE subject within a school
Design elements
31. What
* Charts and Pictograms - Charts and pictures can present observation data in colourful ways to make your portfolio appear more interesting.
| Used to keep track of all the financial transaction in a business such as all items purchased, all bills paid, and all payroll calculations
13. Which of the following characteristics makes it EASIER to measure the quality of a service, relative to that of a product or facilitating good?
When a new column is added to a spreadsheet it is added to the _____ of the selected column. (Unit 5)
· Identify the type of chart or graph and what this type of chart or graph usually depicts. Pie charts, for example, show portions of the whole and line charts show trends over time.
After each procedure, a graph was created for each set of data to compare and contrast results.
11. For each of the following, indicate whether you would use a pie, line, or bar chart, and why.
• Provide at least two examples or problem situations in which statistics was used or could be used.
One of the most common technology used for outlining subconsciously using graphs, bar charts, especially the one that shows all the information in the order, or bar charts, histograms, which is among a wider group.
I would use a bar graph because it would be easy to follow and understand the information presented.
Scenario 1: A business professional calls the support desk looking to use Excel to organize data for the monthly expense report. He has never used Excel prior to this and has inquired about the functions that would support him with his task.
Prior to this course I have used statistics in my professional life. During my previous employment at the University of Tennessee, College of Veterinary Medicine I worked in the student admissions which made my primary job focus the student application process. This process required me to compile statistical information on our applicant pool for faculty and administrative staff to determine who would be accepted. This statistical data included both categorical data, such as current grade level in undergraduate studies, gender, and ethnicity, as well as numerical data such as age, GPAs, average number of courses taken in a semester, credit hours completed, and test scores (Mirabella, 2011). After the admissions process was completed, these different
Bar charts are very useful when you want to show or compare quantities over time, such as long distances charges for the months July, August, and September.
ii) Function How the function would