營銷調研基礎如何使用EXCEL進行市場的研究數據分析ppt課件

1、Using Microsoft Excel with Exploring Marketing ResearchTITLE BARMENU BARFORMULA BARSTANDARD TOOLBARFORMATTING TOOLBARACTIVE CELLPASTE FUNCTIONTOOLS MENUThe Paste Function Provides Numerous Statistical OperationsThe Statistical Function CategoryData Analysis Dialog Box Click on “Tools Select “Data An

2、alysis Select statistical operation such as HistogramFunctions Functions are predefined formulas for mathematical operations They perform calculations by using specific values, called arguments Arguments indicate data or a range of cells Arguments are performed, in a particular order, called the syn

3、tax. Functions Functions are predefined formulas for mathematical operations They perform calculations by using specific values, called arguments Arguments are performed, in a particular order, called the syntax. For example, the SUM function adds values or ranges of cellsEasy to Use Paste Functions

4、 AVERAGE (MEAN) MEDIAN MODE SUM STANDARD DEVIATIONFunctions The syntax of a function begins with the function name followed by an opening parenthesis the arguments for the function separated by commas a closing parenthesis. If the function starts a formula, an equal sign (=) is typed before the func

5、tion name. The Equal Sign Then The Function Name And Arguments =FUNCTION (Argument1) =FUNCTION (Argument1,Argument2)Arguments Typical arguments are numbers, text, arrays, and cell references. Arguments can also be constants, formulas, or other functions. The AVERAGE Function Located in the Statistic

6、al CategoryData Array The data appear in cells A2 through 14 A2:A14 Sometimes written with dollars signs $A$2:$A$14Sum, Average, and Standard Deviation =FUNCTION (Argument1) =SUM(A2:A9) =AVERAGE(A2:A9) =STDEVA(A2:A9)SUM FunctionSales Call Example)9:2(AASUMX AVERAGE (Mean) FunctionSales Call Example)

7、9:2(AAAVERAGEnXXiStandard Deviation FunctionSales Call Example)9:2(12AASTDEVAnxxxsProportion =COUNT =COUNTIF DIVIDE COUNTIF BY COUNT =D3/D2Frequency Distributions There are alternative ways of constructing frequency distributions COUNTIF function HISTOGRAM function=COUNTIF(A6:A134,1)=D4/D9*100Histog

8、ram Function Tools -Data Analysis-Histogram BinsThe bins are thefrequency categoriesInsert Input and Bin RangesText Labels Can Be Included or Excluded From Input RangeThe Chart WizardThe Descriptive Statistics FunctionSEVERAL ROWS OF DATA ARE HIDDENSEVERAL ROWS OF DATA ARE HIDDENCorrelationCorrelation Coefficient, r = .75Correlation: Player Sala