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 set in the Introduction in terms of where this data set came from and what plan to do with the data set ( Objective and Problem Statement ) 3 In the Methodology and Results section, conduct the following analysis Design TWO queries using logical functions Design a retrieval application using a combination of VLOOKUP MATCH INDEX IF functions Design a PivotTable , and use this Table to show extract TWO different information and visualise this information using PivotChart Create FOUR different charts and ONE combination chart Create ONE sparklines Comment on the frequency distribution and histogram of a categorical variable Comment on the frequency distribution and histogram ofa numerical variable Comment on the mean , median and mode for one of the variable Use the Excel Descriptive Statistics Tool , compare the numerical statistical measures for two of the variables Investigate the relationship between two variables, and interpret the coefficient Build a regression model , and use this model for a prediction what the results and conclusion

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 08, 2024

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.