Prior to beginning work on this assignment, read Chapter 4 of your textbook, inc

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

Prior to beginning work on this assignment, read Chapter 4 of your textbook, including the Brief Case “Cost of Living” at the end of Chapter 4 on page 143 and access the Numbeo Northern America: Current Cost of Living Index by City (numbeo.com) (https://www.numbeo.com/cost-of-living/region_rankings_current.jsp?region=021)
In this assignment, you will be analyzing the Cost of Living Index and the Groceries Index for seven U.S. cities and creating a scatterplot to identify the relationships between the variables. You may choose any seven U.S. cities you wish.
Go to the Numbeo Northern America: Current Cost of Living Index by City (numbeo.com) (https://www.numbeo.com/cost-of-living/region_rankings_current.jsp?region=021) and then follow directions below to get started:
Identify seven cities and note the “Cost of Living Index” value and the “Groceries Index” value.
Develop a table with three columns:
City
Groceries Index (independent variable)
Cost of Living Index (dependent variable)
Complete one row for column titles (City name, Groceries Index, and Cost of Living Index) and seven rows that show the city name, Groceries Index and the Cost of Living index.
In your Excel spreadsheet or tool of your choosing you will have developed a table with three columns, one row for titles, and seven rows containing data for each city you selected. In Excel or the software of your choosing:
Insert or draw a scatterplot of the selected data set.
Display the regression line (also called the trend line, linear model, or line of best fit). In Excel click anywhere in the scatterplot. Click on the plus sign and at the bottom of Chart Elements select “Trend line.”
Display the equation for the trend line and R2 value on the graph. In Excel right click on the trend line. View the options on the right of the chart under “Format Trendline” and scroll to the bottom to select the boxes for display equation on chart and display R-squared on chart options.
In your paper:
Cite the URL and complete an APA reference for the URL.
Provide the table with your data and your spreadsheet of the graph with the equation and R2
Analyze your findings of the best and worst cities that predict the relationship between the Groceries Index and Cost of Living Index.
Assess the relationship between the Groceries Index and Cost of Living Index in the cities you studied.
The assignment
Must include a separate title page with the following:
Title of paper in bold font
Space should appear between the title and the rest of the information on the title page.
Student’s name
Name of institution (University of Arizona Global Campus)
Course name and number
Instructor’s name
Due date
Must utilize academic voice. See the Academic Voice (Links to an external site.) resource for additional guidance.
Must include an introduction and conclusion paragraph. Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.
For assistance on writing Introductions & Conclusions (Links to an external site.) as well as Writing a Thesis Statement (Links to an external site.), refer to the Writing Center resources.
Must use at least one credible source in addition to the course text.
The Scholarly, Peer-Reviewed, and Other Credible Sources (Links to an external site.) table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.
Must document any information used from sources in APA Style as outlined in the Writing Center’s APA: Citing Within Your Paper (Links to an external site.) guide.
Must include a separate references page that is formatted according to APA Style as outlined in the Writing Center. See the APA: Formatting Your References List (Links to an external site.) resource in the Writing Center for specifications.
Required Resources
Text
Sharpe, N. D., De Veaux, R. D., & Velleman, P. F. (2019). Business statistics (4th ed.). Retrieved from https://www.redshelf.com
Chapter 3: Describing, Displaying, and Visualizing Quantitative Data (AIG)
Chapter 4: Correlation and Linear Regression (Zillow.com)
Book
Tetlock, P.E & Gardner, D. (2015). Superforecasting: The art and science of prediction. Retrieved from https://www.redshelf.com
Chapter 3: Describing, Displaying, and Visualizing Quantitative Data (AIG)
Chapter 4: Correlation and Linear Regression (Zillow.com)
Web Pages
Numbeo. (n.d.). Northern America: Current cost of living index by city (Links to an external site.). Retrieved from https://www.numbeo.com/cost-of-living/region_rankings_current.jsp?region=021
This web page provides information about the cost of living in various cities and will assist you in your Identifying Relationships Between Variables assignment this week.
Accessibility Statement does not exist.
Privacy Policy (Links to an external site.)
United States Census Bureau. (n.d.). Library: Infographics & visualizations (Links to an external site.). Retrieved from https://www.census.gov/library/visualizations.html
This web page provides infographics and visualizations representing various data sets collected by the U.S. Census Bureau. It will be useful in your Interpretation of Quantitative Distributions Peer Feedback discussion forum this week.
Accessibility Statement (Links to an external site.)
Privacy Policy (Links to an external site.)
U.S. Small Business Administration. (n.d). Office of Entrepreneurship Education | Resources (Links to an external site.). Retrieved from https://www.sba.gov/offices/headquarters/oee/resources/2836
This web page provides general business and data statistics collected by the U.S. Small Business Administration. It will be useful in your Interpretation of Quantitative Distributions Peer Feedback discussion forum this week.
Accessibility Statement (Links to an external site.)
Privacy Policy (Links to an external site.)
Websites
United States Census Bureau (Links to an external site.). (https://www.census.gov/)
This website provides access to U.S. data gathered by the U.S. Census Bureau. It will be useful in your Interpretation of Quantitative Distributions Peer Feedback discussion this week.
Accessibility Statement (Links to an external site.)
Privacy Policy (Links to an external site.)
U.S. Department of Commerce, Bureau of Economic Analysis (Links to an external site.). (https://www.bea.gov/)
This website provides access to federal economic data sets gathered by the Bureau of Economic Analysis. It will be useful in your Interpretation of Quantitative Distributions Peer Feedback discussion forum this week.
Accessibility Statement (Links to an external site.)
Privacy Policy

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services