Question: I need help understanding how to create a scatter plot chart for the following information. The Excel chart I created did not turn out very

I need help understanding how to create a scatter plot chart for the following information. The Excel chart I created did not turn out very well. I am not sure what I have did wrong. Please help!

b = billions

Year	Sales	Net Income
2022	81.462b	12.583b
2021	53.823b	5.524b
2020	31.536b	0.69b
2019	24.578b	0.862b
2018	21.461268b	0.977b

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Cars-to-Dealers Logistics Inc. is the exclusive logistics provider for the Summit Motor Co. and has responsibility for transporting cars from Summit's 3 manufacturing plants in Toledo, OH; Charlotte,...

Exp 2 2 _ Excel _ Ch 0 8 _ CumulativeAssessment _ Variation - Real Estate Valuation Exp 2 2 Excel Ch 0 8 CumulativeAssessment Variation Real Estate Valuation Excel Chapter 8 Cumulative Assessment -...

PROJECT SPECIFICATIONS The information provided in this test allows you to set up the General, Payables and Receivables ledgers for an Ontario company named GEORGE'S WELDING owned and run by Chris...

WHAT FINAL EXCEL SHOULD LOOK LIKE: EXCEL GIVEN: Exp19_Excel_Ch08_CapAssessment_Employee_Satisfaction Project Description: You work as a data analyst for Camino Marketing, a U.S.-based web marketing...

Show step by step in excel \fH4 Jx A B C D G H K N P Home Valuation Worksheet Purchase Date Sqft Purchase Price Current Value Sqft Frequency BIN Frequency Standard Deviation 3/1/21 904 71,252.00 5...

AMAZON.COM, INC. Income Statement Data All numbers in $ millions except EPS Fiscal Year (December, 31) 2014 2013 2012 2011 2010 2009 2008 Sales 88988 74452 61093 48077 34204 24509 19166 Cost of Goods...

the project answer should be based on a topic name (driving and drinking in canada ) so please answer all the requested thank you sorry the first page i posted is not the right one the second one is...

please choose drinking and driving in Canada to fo this project Objectives: . collect data for the past twenty years/months (at least 20 data points) concerning a topic of your choice (samples below)...

Step Instructions Point Value 1 Start Excel. Download and open the file named Exp19_Excel_Ch08_CapAssessment_EmployeeSatisfaction.xlsx. Grader has automatically added your last name to the beginning...

Do a simple profitability and growth analysis of a company of your choice as follows. Obtain financials for your chosen company from Standard & Poors NetAdvantage database available through VCU...

A) What are the main difference between financial accounting and management accounting? (6 marks) B)Identify each of the following questions as being more likely by an internal user or external user...

Kerri James is considering buying a car. She wants to buy the new VW Beetle that will cost her $17,600, she says. It will finance 90% of the purchase price (i.e. make a 10% down payment) at an annual...

28. GDP is GPI. (LO8) a) much higher than b) about the same size as c) much lower than

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

Identify the types of informal reports.

Write messages that are used for the various stages of collection.

Describe the four elements that are encompassed in the indirect plan for persuasive messages.