Solution manual
Essentials of modern business statistics with
Micro-soft excel 8th edition by Anderson
,TABLE OF CONTENT S S
1. Data and Statistics.
S S S
2. Descriptive Statistics: Tabular and Graphical Displays.
S S S S S S
3. Descriptive Statistics: Numerical Measures.
S S S S
4. Introduction to Probability.
S S S
5. Discrete Probability Distributions.
S S S
6. Continuous Probability Distributions.
S S S
7. Sampling and Sampling Distributions.
S S S S
8. Interval Estimation.
S S
9. Hypothesis Tests.
S S
10. Inferences About Means and Proportions with Two P
S S S S S S S S
opulations.
11. Inferences About Population Variances.
S S S S
12. Test of Goodness of Fit, Independence, and Multiple
S S S S S S S S S
Proportions.
13. Experimental Design and Analysis of Variance.
S S S S S S
14. Simple Linear Regression.
S S S
15. Multiple Regression.
S S
Chapter 1 S
,Data and Statistics
S S
LearningSObjectives
1. ObtainSanSappreciationS forStheSbreadthS ofSstatisticalSapplicationsSinSbusinessSandSeconomics.
2. UnderstandStheSmeaningSofStheStermsSelements,Svariables,SandSobservationsSasStheySareSusedSin
S statistics.
3. ObtainSanSunderstandingSofStheSdifferenceSbetweenS categorical,Squantitative,Scross-
sectional,SandS timeSseriesSdata.
4. LearnSaboutStheSsourcesSofSdataSforS statisticalSanalysisSbothS internalSandSexternalStoStheSfirm.
5. BeSawareSofShowSerrorsScanS ariseSinSdata.
6. KnowStheSmeaningSofSdescriptiveSstatisticsSandSstatisticalSinference.
7. BeSableStoSdistinguishSbetweenSaSpopulationSandSaSsample.
8. UnderstandStheSroleSaSsampleSplaysSinSmakingSstatisticalSinferencesSaboutStheSpopulation.
9. KnowStheSmeaningSofStheStermsSanalytics,SbigSdataSandSdataSmining.
10. BeSawareSofSethicalSguidelinesSforS statisticalSpractice.
, Solutions:
1. StatisticsScanSbeSreferredStoSasSnumericalSfacts.SInSaSbroaderSsense,SstatisticsSisStheSfieldS ofSstudy
S dealingSwithStheScollection,Sanalysis,S presentation,SandSinterpretationS ofSdata.
2. a. TheStenSelementsSareStheStenStabletScomputers.
b. FiveSvariables:SCostS($),SOperatingSSystem,SDisplaySSizeS(inches),SBatterySLifeS(hours),SCPU
S Manufacturer
c. CategoricalSvariables:SOperatingSSystemSandSCPUSManufacturer
QuantitativeSvariables:SCostS($),SDisplaySSizeS(inches),SandSBatterySLifeS(hours)
S
d.
SS Variable MeasurementSScaleS
CostS($) Ratio
OperatingSSystem Nominal
DisplaySSizeS(inches) Ratio
BatterySLifeS(hours) Ratio
SS CPUSManufacturer NominalS
3. a. AverageScostS=S5829/10S=S$582.90
b. AverageScostSwithSaSWindowsSoperatingSsystemS=S3616/5S=S$723.20
S AverageScostSwithSanSAndroidSoperatingSsystemS=S1714/4S=S$428.5
S TheSaverageScostSwithSaSWindowsSoperatingSsystemSisSmuchShigher
c. 2. SofS10SorS20%SuseSaSCPUSmanufacturedSbySTISOMAP.
d. 4SofS10SorS40%SuseSanSAndroidSoperatingSsystem.
4. a. ThereSareSeightSelementsSinSthisSdataSset;SeachSelementScorrespondsStoSoneSofStheSeightSmodelsSof
S cordlessStelephones.
b. CategoricalSvariables:SVoiceSQualitySandSHandsetSonS Base
QuantitativeSvariables:SPrice,S OverallSScore,SandSTalkSTime
c. PriceS–SratioSmeasurement
OverallSScoreS–
SintervalSmeasurementS VoiceSQualityS–
SordinalSmeasurementS HandsetS onSBaseS–
SnominalSmeasurementS TalkSTimeS–
SratioSmeasurement
5. a. AverageSPriceS=S545/8S=S$68.13
b. AverageSTalkSTimeS=S71/8S=S8.875Shours
c. PercentageSratedSExcellent:S 2SofS8 2/8S=S.25,SorS25%
4S-S2
