Answered step by step
Verified Expert Solution
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
\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} -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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started