How to make a market survey form?

Question 1: How is the market survey form made? According to commercial, residential, T-building and other real estate projects with different uses, different survey forms are formulated. , should include the name of the project under investigation, the average market price (selling price, rent), the basic information of the project (building area, building area, plot ratio, planned use, land tenure, ownership), infrastructure, public facilities, etc.

Question 2: How to make a market analysis table with excel as follows:

1. You need to add Analysis Toolbox to the add-in in Excel options before you can see Data Analysis under Data options.

2. Data processing stage:

Excel will be used at this time. First of all, we must make a big clean-up of the data! Filter and remove redundant data, make up missing data, and correct or delete erroneous data.

A series of functions are used:

Data duplication (COUNTIF function), delete duplicates.

Missing data IF and/or nested functions, etc.

Data sampling left and right, connection (text 1, text 2 ...), VLOOKUP.

The data calculates the average, sum, maximum, minimum and date, if.

VLOOKUP data grouping function, using approximate matching and search function.

RAND function of data sampling, RAND ()

The above are just some simple explanations, and specific problems need to be analyzed according to needs.

Question 3: What should market research do? Market research should achieve 20 points.

1. Market research: Market research in a broad sense is to collect and analyze all information related to product sales from production to consumption by scientific methods and means, such as product production, pricing, packaging, transportation, wholesale and retail, product promotion, sales strategy, channels and market development, as well as social, political and economic situation. Market survey in a broad sense includes: market environment survey, consumer demand survey, consumption pattern survey, product, pricing, sales channel survey, advertising effect survey, corporate image survey, consumer living habits survey, political and economic situation survey, etc. In a narrow sense, market research refers to the work of collecting consumers' opinions on products (or services) and information such as the purchase, use and sales of products (or services) through scientific methods and means.

2. Questionnaires: Questionnaires are a major survey method, which is widely used in advertising surveys. Questionnaires can be conducted by a few investigators in a short time, especially by mail, which is not limited by geographical conditions and can reach a wide range; The time for respondents to fill in the questionnaire is generally flexible and can be filled in at a convenient time according to their own situation. Compared with interviews, questionnaires help respondents to answer questions; It is conducive to avoiding all kinds of deviations caused by human factors and reflecting the situation more truly; The survey results are convenient for quantitative analysis and processing. The key of questionnaire survey is to design a questionnaire; Let the respondents actively cooperate and answer realistically; Easy to recover, treat and analyze; The need to be able to complete the survey questions. The design of the questionnaire should be concise, and the respondents generally need to have a certain cultural level and be able to read and understand the meaning of the question and the methods to answer the question. Otherwise, when the respondents are not clear about some questions, it is easy to get wrong answers. The weaknesses of questionnaire survey are: the response rate of questionnaire is not easy to guarantee (especially email questionnaire); Emphasis on quantitative analysis is not easy to understand the reasons.

3. Advertising survey: the general name of all survey activities accompanying advertising activities. The details are as follows: 1. Investigate to find or determine the appeal point of advertising; 2. Investigation to identify consumers or advertising targets; 3. Investigation on the number of media; 4. Investigation of media characteristics; 5. Media contact rate survey (ratings, listening rate, attention rate, etc. ); 6. Research on the measurement of advertising effect; 7. Commodity (enterprise) image survey; 8. Investigation on consumers' purchasing motives; 9. Market advertising investment survey.

4. Media survey: A survey of the function, characteristics and actual situation of advertising media, with the purpose of determining the value and qualitative value of advertising media. The contents of the survey mainly include: the geographical distribution of the media, the popularity of the media, the social class of the media audience, the consumption level, the contact with the media, and the audience's reflection and evaluation of the media.

5. Content analysis: It is an important method to study and analyze the communication content by using objective and quantitative classification survey technology. Content analysis is an important means of mass communication research, which originated in the United States in the 1920s. At first, it was a relatively simple research method to grasp the layout tendency by classifying news reports. Later, the appearance of computers made it possible to make complex data statistics, so content analysis became an important research method in parallel with effect analysis. In the practice of advertising activities, content analysis method is not only limited to the analysis of advertising effect, but also combined with the investigation method of advertising volume. Through the statistical analysis of advertising works, it plays an increasingly important role in grasping competitors' advertising strategies and understanding their own market positioning.

6. Consumer survey: it is one of the contents of advertising survey, which mainly refers to the investigation and research on the number, distribution, purchase motivation, purchase habits, consumption demand, consumption psychology, hobbies and behaviors, their age, gender, education level, family status, race, nationality and religious beliefs, and is the basis for formulating enterprise marketing strategies and advertising strategies.

Through the investigation of consumers, we can analyze why consumers buy, what they buy, who buys, when, where, how and how often they buy products. It can analyze consumers' purchasing power, consumption habits, hobbies and various hopes for products and make purchases >>

Question 4: How to do product market research? 1, Pepsi specifications-including bottled and canned; 2. Prices of various specifications-including ex-factory price, prices supplied to various sales terminals and final selling price; 3, channel research-including the main sales channels of Pepsi, hotels, supermarkets, convenience stores and other channels that can be sold; 4. Promotion-Pepsi's brand communication mode, brand positioning and comments. 5. Recent promotion activities-Pepsi's recent promotion methods and efforts. That's about it. You can add some. The most important thing is that you need to do research in that field.

Question 5: How to make a market survey design table? 1. Identify problems and assumptions

Because the main purpose of market research is to collect and analyze information, so as to help enterprises make better decisions and reduce decision-making mistakes, the first step of the survey requires decision makers and investigators to carefully determine and agree on the research objectives. As the saying goes, a proper definition of a problem is half the solution. There are many things to examine on any issue. If the problem is not clearly defined, the cost of collecting information may exceed the value of the results of the investigation. For example, a company finds that its sales volume has declined for six months in a row, and managers want to know what the real reason is? Is it a recession? Reduced advertising spending? Consumers prefer change? Or is the agent's sales promotion invalid? Market researchers should first analyze relevant information, then find out research problems, make further assumptions and put forward research objectives. If the investigators think that the above problems are changes in consumer preferences, they will further analyze and put forward some assumptions. For example: ① consumers think that the company's product design is outdated; ② The advertising design of competitive product brands is better.

The main reason for putting forward the hypothesis and giving the research goal is to limit the scope of the investigation, and to test whether the hypothesis is established and write the investigation report from the data obtained from the subsequent investigation.

2. Determine the required information

3. Determine the way to collect information

The third step requires the formulation of the most effective way to collect the required information, and it needs to be determined: data source, survey method, survey tool, sampling scheme and contact information.

If there is no suitable ready-made information (second-hand information), the collection of original information (first-hand information) becomes a necessary step. The way data is collected is related to the nature of the data needed. It includes experimental method, observation method and inquiry method. As mentioned in the previous example, the information needed is about the attitude of consumers, so market researchers can use inquiry to collect information. Personal interviews are more suitable for the investigation of consumers and facilitate in-depth communication between them.

4. Sampling design should decide who the sampling object is at the stage of investigation and design, which puts forward the problem of sampling design. First, whether it is probabilistic sampling or non-probabilistic sampling depends on the accuracy required by the survey. Probability sampling has high estimation accuracy and can estimate sampling error. In terms of statistical efficiency, probability sampling is naturally better. However, from an economic point of view, non-probabilistic sampling design is simple and can save time and cost. Second, a problem that needs to be decided is the number of samples, which needs to take into account the issues of statistics and economic efficiency.

5. Data collection Data collection must be completed by investigators, and the quality of investigators will affect the correctness of the survey results. Investigators are very suitable for college students majoring in marketing, psychology or sociology, because they have been trained in survey techniques and theories, which can reduce survey errors.

6. After data analysis and data collection, all the answers should be checked, and incomplete answers should be considered for elimination, or the respondents should be asked again to fill the gaps in the data.

In data analysis, the analysis results should be compiled into statistical tables or charts to facilitate readers to understand the analysis results, and the relationship between the analysis results and the assumptions determined in the first step can be seen from the statistical data. At the same time, the results should be expressed in the form of percentage and average of various data, so that readers can form a clear contrast with the analysis results. However, whether the difference between the percentage and the average value of various data is really statistically significant should be determined by using appropriate statistical test methods. For example, on the surface, there is a difference in the monthly consumption expenditure of some household items between two income families, but whether there is a real difference can be analyzed by the average test method. Data can also be analyzed by some statistical methods, such as correlation analysis and regression analysis.

7. Investigation Report The last step of market investigation is to prepare a written report. Generally speaking, written investigation reports can be divided into two categories: ① special reports; (2) popularity report.

The readers of the special report are interested in the whole survey design, analysis methods, research results and various statistical tables, and they already know the technology of market research. Readers of popular reports are mainly interested in listening to the suggestions of market research experts. For example, senior decision makers in some enterprises. 00

Question 6: What is a market survey form? See what kind of data you want in the survey! By investigating the problem, we must choose the correct investigation object! The questions raised should serve the final conclusion!

Question 7: How to do market research? 1) investigation preparation stage 1. Clarify the theme of market research. 2。 Determine the investigation items. 3。 Determine the survey object and survey unit. 4。 Determine the ways and methods of investigation. 5。 Make an investigation plan. 6。 Form an investigation team. (2) Formal investigation stage 1. Collection of ready-made data. 2。 Collection of raw data. (III) Result processing stage 1. Review and revise. 2。 Group summary. 3。 Analytical research. Prepare investigation report

Question 8: How to make the catering market survey form? The basic elements of a market survey report generally have three elements. First, the basic situation. That is, the description and explanation of the survey results can be explained by words, charts and figures. The introduction should be detailed and accurate, providing a basis for the following analysis and conclusions. Second, analysis and conclusion. Scientifically analyze the above data, find out the reasons and the influence of various factors, see the essence through the phenomenon, and give the respondents a clear conclusion. Third, measures and suggestions. By analyzing the survey data, we have a clear understanding of the market situation. In view of the contradiction between market supply and demand and the problems found in the investigation, some suggestions and opinions are put forward for the leaders to make decisions. There are four basic methods of market research in relevant links, namely, general survey, sampling survey, typical survey and key survey. The commonly used concrete methods mainly include: inquiry, observation, experiment and data research. Third, the structure and writing of the market survey report

Question 9: How to make a market research table? 10 I am a graduate majoring in marketing, and I am taking the postgraduate entrance examination. I often come to exchange ideas. Maybe I can help you, or you can help me.

Because the map can't come, go to this website and have a look:

Methods and operating procedures of market research

First of all, what is market research?

Market research is a process of systematically and objectively identifying, collecting, analyzing and disseminating information in order to improve and correct enterprise marketing decisions.

The key to marketing is to find and meet the needs of consumers. In order to judge the requirements of consumers and implement the marketing strategic plan to meet the needs of consumers, marketing managers need to have a good understanding of consumers, competitors and other forces in the market. Especially in recent years, the emergence of many factors has prompted people to have greater demand for the quality and quantity of information. With the development of economic globalization, international marketing urges enterprises to have higher and wider demand for information; With the improvement of consumption consciousness, marketing decision makers of enterprises need to have a more accurate and in-depth understanding of consumers' consumption habits and trends; With the intensification of market competition and the acceleration of market changes, we must also have a deeper and faster understanding and response to marketing strategies and tools (Figure 2).

The importance of market research can be seen from the "Model of Marketing Research in the Whole Management" in Figure 3 below.

Second, the operating procedures of market research

Market research is a highly scientific and systematic work. It is a method for researchers to collect target materials, sort out and count the collected materials, and then analyze the statistical results in order to provide correct predictions for enterprise decision-making. Market research must be carried out around a theme, and its work composition must follow strict and reasonable working procedures. Specifically, it includes three parts: asking questions, investigating and collecting materials, and analyzing and predicting problems.

Specifically, the research process includes the following steps:

1, find a problem, or ask a question.

2. Determine the research topic.

(1) to determine the data acquisition range.

(2) Determine the research topic.

3. Research and design

(1), and determine the research purpose.

(2), determine the source of the data

(3) Determine the research tools and methods.

(4), determine the researchers

(5) Select the survey sample.

(6) Budget of funds and time

(7), make a marketing plan

4, the implementation of the research plan

(1), data collection

(2), data processing

(3), data analysis and interpretation

5. Submit a study report

Three. Description of operating procedures of market research

A, find and ask questions

The market is ever-changing, and it has certain stability in time and space, which includes internal factors and external factors of enterprises. Therefore, if enterprises want to understand the changes of internal and external factors in the market, they can only make appropriate business strategic decisions if they have a necessary understanding of the market situation.

For enterprises, when preparing for market research, most of them are prepared to make major business strategic decisions, or adjust marketing, or encounter major problems and want to know the ultimate source of their own problems.

When analyzing the problem, we can start from the following aspects:

1. Analyze the current situation of the enterprise, what market problems the enterprise is currently facing, and the corresponding measures that should be taken when finding such problems;

2. Potential problems are hard to find and need careful observation and analysis;

3. Plan new markets and predict possible problems;

4. Among many problems affecting the market, which one is worth analyzing;

5. The future market that the enterprise hopes.

After the market problem is clear, it is helpful to draw up the framework of market research, and make clear the goal of market research and the corresponding marketing strategy.

B, determine the research topic

1, to determine the scope of data collection.

(1), market conditions. Internal and external environmental data of the industry and the overall market trend, so as to analyze the macro market trend;

(2), enterprise internal environment analysis. Including enterprise marketing structure, enterprise's response to market changes, products, prices, channels, promotion, service system and so on.

(3), product changes. Understand the advantages and disadvantages between products and competing products, understand the opinions of internal personnel such as production department and marketing department, and the opinions of external personnel such as distributors and enterprises with certain cooperative relations such as raw material suppliers;

(4)、......& gt& gt

Question 10: How to do market research? First, determine the purpose and object of the survey, and set questions according to the questions you want to know. There are many kinds of topics, such as: closed and open; Sorting type, wheelbase type, etc. These methods have their own characteristics, depending on what kind of data you need and the direction you want to know. There is a specific explanation in the market survey.