In this assignment, you will use data on car prices to create charts in Excel and calculate statistical measures from the data. The data is provided in the Auto Data [XLSX] document. It contains information on 82 used cars that are for sale, specifically, the asking price, the model year, the mileage, the color, and the trim. Instructions Part 1 Use the information provided in Auto Data [XLSX] to create the following: A bar chart using either the color or trim variable. Make sure you include a title for the plot and label all axes correctly. A pie chart using either the color or trim variable. Make sure you include a title for the plot and label the sectors of the chart correctly. A scatterplot using the miles and asking price. Make sure you include a title for the plot and label all axes correctly. Part 2 Use the information provided in Auto Data [XLSX] to calculate the following: The mean and median for the asking price and miles variables. The (sample) standard deviation for the asking price and miles variables. The proportion of luxury cars and the proportion of performance cars. Part 3 In a Word document, write a 2–3 paragraph summary of your findings: What are two interesting findings when looking at the charts in Part 1? How would the charts help you make an informed decision if you were in the market for buying a vehicle? 2.First, type your essay into the The Story of You Template [DOCX] Download The Story of You Template [DOCX], and then record the speech. You will submit two files (your Word document and your audio or audiovisual file or link) to the assignment dropbox. Complete the following steps: Describe three sociological concepts or theories that connect to your personal or professional life. Following the div, include an introduction (one paragraph) in which you identify these concepts and theories in boldface. Your introduction should also include a clear thesis statement (the main idea of your speech). You can choose to relate these concepts and theories to your personal life (your experiences in your family, neighborhood, or schools you attended, for example) or to your career. Explain how sociological concepts or theories connect to your personal or professional life. Following the div, write one paragraph for each concept or theory (three paragraphs total), applying the concepts or theories to your experiences or observations. Include examples from your personal or professional life to illustrate each concept or theory. Relate sociological concepts or theories to specific learning outcomes. Following the div, explain (in one or two paragraphs) how an understanding of one or more of the sociological concepts or theories you have discussed can help you improve your ability to collaborate with others and further develop one or more of the three essential learning outcomes: personal and social responsibility, problem solving, and relationship building. Use evidence from the course material or other sources to support your points. Identify a sociological research question based on your observations or experiences. Following the div, include a sociological research question that is based on your story and reflects something you are interested in learning more about. For example, if you wrote about some of the challenges you faced in the education system, your research question might be: what programs or policies have been found to improve the quality of K-12 education in impoverished areas? If you wrote about your frustration with groupthink in the workplace, your question could be: what are the best strategies for reducing the negative aspects of groupthink in today’s workplace? For more research question ideas, see Chapter 3 in your textbook. Describe how you would use the scientific method to study your proposed research question. Following the div, write a paragraph in which you discuss steps you would take to answer your research question, based on your understanding of the scientific method, which is covered in Chapter 3 of your textbook. Following the div, include a conclusion that sums up what you have learned and/or what your audience has learned about you. Demonstrate effective audio presentation skills. Use Kaltura to record an audio file to accompany your essay. You also have the option to record a video (with audio) if you prefer. Refer to Using Kaltura if you need help using this courseroom tool. In your recording, include the following elements: Name the three concepts or theories you focused on, with an example of how you applied one of them to your personal or professional life Describe how your understanding of one of these concepts or theories can help you improve or develop one of the skills you explored in this course (problem solving, personal and social responsibility, and relationship building). Discuss the research question you chose and your ideas for how to answer that question. Write in a well-organized and concise manner that adheres to the rules of grammar, usage, and mechanics. Examples of sociological concepts and theories: Sociological imagination. Conflict theory. Symbolic interaction theory. Functionalism. Culture. Norms. Values. Status. Roles. Groupthink. Primary and secondary groups. Bureaucracy.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|