Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Download a data set from Kaggle.com . can trim the dataset, but it must consist of at least 100 observations. 2. Describe the data

1. Download a data set from Kaggle.com. can trim the dataset,but it mustconsist of at least 100 observations.

2. Describe the data setin theIntroductionin terms ofwhere this data set came fromandwhat plan to dowith the data set (ObjectiveandProblem Statement)

3. In the Methodology and Resultssection, conduct the following analysis:

  • DesignTWO queriesusinglogical functions
  • Designa retrieval applicationusing a combination ofVLOOKUP/MATCH/INDEX/IF functions
  • Designa PivotTable, anduse this Tableto show/extractTWO different information and visualisethis information using PivotChart
  • CreateFOUR different chartsandONE combination chart
  • CreateONE sparklines
  • Commentonthe frequency distribution and histogramof acategorical variable
  • Commentonthe frequency distribution and histogramofanumerical variable
  • Commentonthe mean,medianandmodefor one of the variable
  • Use the Excel Descriptive Statistics Tool,comparethe numerical statistical measures for two of the variables
  • Investigatethe relationship between two variables, andinterpretthe coefficient
  • Build a regression model, and use this model for a prediction.

*what the results

* and conclusion

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

Oscillations In Nonlinear Systems

Authors: Jack K Hale

1st Edition

0486803260, 9780486803265

More Books

Students also viewed these Mathematics questions

Question

=+10. What is the brand's character or personality?

Answered: 1 week ago