Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

If we have this table below and we want -Examine the data provided in the dataset very carefully. -Apply data exploratory tools (descriptive statistics and/or

If we have this table below and we want
-Examine the data provided in the dataset very carefully.
-Apply data exploratory tools (descriptive statistics and/or charts) to develop and support your insights.
-Apply 'Correlation Trend Line' tool to even derive more and better insights.
please answer me in showing it in excel and under it an explantion
please answer me in less than 2 hours
image text in transcribed
\begin{tabular}{|r|r|r|r|r|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{2}{c|}{ C } & \multicolumn{1}{c|}{ D } \\ \hline Year & Sales & Price & \multicolumn{1}{l|}{\begin{tabular}{l} Comp. \\ Income \end{tabular}} \\ \hline 2000 & 350000 & 40 & 2500 & 42 \\ \hline 2001 & 370000 & 39 & 2700 & 42 \\ \hline 2002 & 385000 & 38 & 2900 & 42 \\ \hline 2003 & 405000 & 37 & 3100 & 42 \\ \hline 2004 & 410000 & 37 & 3300 & 42 \\ \hline 2005 & 420000 & 36 & 3500 & 42 \\ \hline 2006 & 500000 & 33 & 3700 & 42 \\ \hline 2007 & 500000 & 34 & 3900 & 41.5 \\ \hline 2008 & 560000 & 32 & 4100 & 41.5 \\ \hline 2009 & 200000 & 55 & 4300 & 41 \\ \hline 2010 & 190000 & 50 & 4500 & 41 \\ \hline 2011 & 180000 & 50 & 4700 & 41 \\ \hline 2012 & 175000 & 48 & 4900 & 41 \\ \hline 2013 & 200000 & 43 & 5100 & 40 \\ \hline 2014 & 200000 & 41 & 5300 & 40 \\ \hline 2015 & 210000 & 40 & 5500 & 38 \\ \hline 2016 & 215000 & 39 & 5700 & 38 \\ \hline 2017 & 220000 & 37 & 5900 & 38 \\ \hline 2018 & 240000 & 34 & 6100 & 38 \\ \hline 2019 & 244000 & 32 & 6300 & 38 \\ \hline 2020 & 235000 & 32 & 6500 & 38 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Essentials

Authors: Frank C Giove

1st Edition

0738671509, 9780738671505

More Books

Students also viewed these Accounting questions

Question

Identify the critical elements in a performance management system

Answered: 1 week ago

Question

Identify the skills necessary for effective coaching

Answered: 1 week ago