100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 2 out of 2 pages.
Data- click data analysis-click what I want- shift control down arrow-see mean etc.d.Flaw of averages-design the cockpits- WW2- around average pilot- not a single person is the average-not about average- about accommodating differences: standard deviation is high: a lot of differences- see where these differences come frome.Look at prices by city!!!i.Way to organize it-ii.PIVOT TABLES: 1.With categorial data- insert- choose pivot table- choose all data- click new worksheet- all headings are on right side- need summary now- take city and drag into rows field- price into values2.categorical data: contains finite number of groups: male or female: types of apple (red orange) product type: laptop or phone- ZIT CODES OR AREA CODES3.continuous data: infinite number of values betweentwo values- daily stock returns/ weights- number itself needs to have meaning4.Present the conclusions
a.Interpret of the output of the analysis and draw conclusions about the answer to your question- Present the conclusions in a manner appropriate to the audience whom you need to informb.Helps lead to better decision makingc.Use descriptive statistics and pivot tablesd.Answer as depends on the city, number of rooms, size of the lot etc.Analytical problem solving summarize