Assignment 3: Supply, Demand, & Government in the Markets

6. Analyze results - Graph the data from Table 4 and describe what your graph looks like (you do not have to submit a picture of the actual graph!).

b) (10 points) Based on your results in a), graph publishers on a bubble chart using the

The file P02_01.xlsx indicates the gender and nationality of the MBA incoming class in two

Present all relevant data in a data table below. Include an observations section for any observations you made during the lab. Make sure you note the data needs to be converted before graphing.

7. Graph the data from Table 1: Water Quality vs. Fish Population (found at the beginning of this exercise). You may use Excel, then “Insert” the graph, or use another drawing program. You may also draw it neatly by hand and scan your drawing. If you choose this option, you must insert the scanned jpg image here.

So my teacher came and showed me how to make one and gave multiple examples on different situations that involved box plots. It was really helpful and I was able to help a couple students in my class thanks to her examples.

You cannot analyze data until you have brought the relevant data that will answer the question you are asking. A new feature of Excel 2016 is the built-in function which makes getting and transforming your data much faster and easier and allows you to find and gather all your data into one place. These new capabilities were only available previously as a separate add-in called Power Query. Now they can be found built into Excel 2016. They can be accessed from the Get & Transform group located on the Data tab.

below by placing the appropriate graph and/or answers in the designated cells of the spreadsheet.

Using either an Excel list or a list imported to Excel, generate form letters and/or mailing labels.

Analyze results - Graph the data from Table 4 and describe what your graph looks like (you do not have to submit a picture of the actual graph!).

2. Beatriz is creating graphs for her city’s Parks Department. Beatriz is trying to persuade the Parks Department to put in more gazebos for shade. For a local park, Beatriz wants to demonstrate the attendance as it changes every week. She also wants to show the temperature changes per month. Sometimes temperatures reach below zero. Explain to Beatriz how to make the graphs correctly based on the data that she will collect and what labels, scales, and intervals each axis must have on each graph. Use complete sentences and support your reasoning. Feel free to generate sample data to help support your response.

5. Analyze results – Assume that your experiment produces results identical to those seen in Table 4, what type of graph would be appropriate for displaying the data and why?

Use the full data set that you uploaded to answer all questions. Be sure to include the graph for ALL questions.

Q7: Create a bar graph or pie chart of the data you have collected. For example, you could create a bar graph that shows the employee turnover rate in organizations that do offer flexible work arrangement compared to organizations that do not. Alternately, you could create a pie chart that shows which types of flexible work arrangement workers want the most.

Data Graph with TITLE: Clear display of a data in graph form (change in dependent compared to independent) with title and axes labeled. Includes units of measurement (grams, pH, time, etc.) and has both dependent and independent variables correctly positioned. NOT to be hand drawn- instead use LoggerPro, Excel, or Create-a-Graph. Check the rubric.