资源描述：
《营销调研基础如何使用EXCEL进行市场的研究数据分析-文档资料.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、UsingMicrosoftExcelwithExploringMarketingResearchTITLEBARMENUBARFORMULABARSTANDARDTOOLBARFORMATTINGTOOLBARACTIVECELLPASTEFUNCTIONTOOLSMENUThePasteFunctionProvidesNumerousStatisticalOperationsTheStatisticalFunctionCategoryDataAnalysis DialogBoxClickon“Tools”Select“DataAnalysis
2、”SelectstatisticaloperationsuchasHistogramFunctionsFunctionsarepredefinedformulasformathematicaloperationsTheyperformcalculationsbyusingspecificvalues,calledargumentsArgumentsindicatedataorarangeofcellsArgumentsareperformed,inaparticularorder,calledthesyntax.FunctionsFunction
3、sarepredefinedformulasformathematicaloperationsTheyperformcalculationsbyusingspecificvalues,calledargumentsArgumentsareperformed,inaparticularorder,calledthesyntax.Forexample,theSUMfunctionaddsvaluesorrangesofcellsEasytoUsePasteFunctionsAVERAGE(MEAN)MEDIANMODESUMSTANDARDDEVIA
4、TIONFunctionsThesyntaxofafunctionbeginswiththefunctionnamefollowedbyanopeningparenthesistheargumentsforthefunctionseparatedbycommasaclosingparenthesis.Ifthefunctionstartsaformula,anequalsign(=)istypedbeforethefunctionname.TheEqualSignThenTheFunctionNameAndArguments=FUNCTION(A
5、rgument1)=FUNCTION(Argument1,Argument2)ArgumentsTypicalargumentsarenumbers,text,arrays,andcellreferences.Argumentscanalsobeconstants,formulas,orotherfunctions.TheAVERAGEFunctionLocatedintheStatisticalCategoryDataArrayThedataappearincellsA2through14A2:A14Sometimeswrittenwithdo
6、llarssigns$A$2:$A$14Sum,Average,andStandardDeviation=FUNCTION(Argument1)=SUM(A2:A9)=AVERAGE(A2:A9)=STDEVA(A2:A9)SUMFunction SalesCallExampleAVERAGE(Mean)Function SalesCallExampleStandardDeviationFunction SalesCallExampleProportion=COUNT=COUNTIFDIVIDECOUNTIFBYCOUNT=D3/D2Freque
7、ncyDistributionsTherearealternativewaysofconstructingfrequencydistributionsCOUNTIFfunctionHISTOGRAMfunction=COUNTIF(A6:A134,1)=D4/D9*100HistogramFunctionTools-DataAnalysis-HistogramBinsThebinsarethefrequencycategoriesInsertInputandBinRangesTextLabelsCanBeIncludedorExcludedFro
8、mInputRangeTheChartWizardTheDescriptiveStatisticsFunctionSEVERALROWS
