Briefly introduce what data mining is and the powerful data mining function of excel. Excel does not support which functions need to be used? Plug-in? .
2. Introduce simple data mining and questionnaire survey.
This paper introduces the most basic data mining method, that is, using? General? This simplest statistical model analyzes the data around you or a small amount of data, and introduces the design skills of questionnaire survey, a commonly used data collection method. By predicting the expected price of goods. It is proved that important information can also be extracted from a small number of samples.
3. Estimate the price of used cars by combining cases.
This paper introduces the knowledge of forecasting and factor analysis through credit regression analysis. Multivariate regression analysis is a very effective statistical method for predicting numerical values and analyzing factors, and it is one of the most commonly used statistical methods in multivariate analysis. Used car data of auction house? Take it as an example. Data includes qualitative data and quantitative data, collectively referred to as? Mixed data? , often appear in the business field.
4. Does the content involve the problem of seeking optimization? Planning a solution?
Excel support? Planning a solution? This powerful tool. In enterprise management, we often encounter the problem of how to maximize turnover and profit and minimize expenses and costs by using limited resources. Using a linear equation to express constraints and goals is called linear programming, and the solution method is called linear programming.
5. Let's learn and analyze the crosstab.
This paper introduces the method of judging whether there are differences in attributes (age, gender, occupation, etc.). ) use a cross table. Solve with the function of Excel; Explain in detail with a large number of examples.