HND统计outcome3

Question1Yearaveragemaximumtemperature198012.25198112.13198212.84198312.78198413.10198511.63198611.63198712.06198812.78198912.99199013.11199112.74199212.53199312.19199412.44199513.35199612.43199713.56199812.94199913.17200013.43200113.04200213.32200313.8711.51212.51313.5141975198019851990199520002005yearaveragemaximumtemperatureaveragemaximumtemperatureAveragemaximumtempratureComment:Fromthechartwecanknowtheaveragemaximumtemperaturehasfluctuatedfrom1980to2003,butthewholetrendisincreased.Question2:a)FinishedOutput(thousandtons)Costofproduction(￡)XYXYXYJanuary292039591318414157521February3324007920010895760000March3225508160010246502500April3425958823011566734025May3322507425010895062500June3524408540012255953600July3426559027011567049025August302050615009004202500September37271010027013697344100October40295011800016008702500337246398378511144961468271=75167/83676.761=0.90b)c)x=39
y=81.615X-286.51y=81.615*39-286.51=2896.475r=2relationshipbetweenfinishedoutputandcostofproductiony=81.615x-286.51200021002200230024002500260027002800290030003100282930313233343536373839404142finishedoutput(thousandtons)costofproduction22222yynxxnyxxynd)Ther=0.90isverycloseto1,thisisindicativeofastronglinearrelationshipbetweencostofproductionandfinishedoutput.Frompart(c)wecanfind,ifthefinishedoutputinNovemberis39thousandtons,thecostofproductionis2896.475,thecostofproductionincreasingasthefinishedoutputincreased.Question3:a)yearquarterrawdata1123105412221118211631084118311252114310841174112421143112411651128211734prescriptionsofeachyear1001051101151201251301234123412341234123412345yearandquarterprescriptionsrawdatab)YearQuarterRawdataMTCMTTrendCMTSV1123105412246121118464925115.6252.3752116460924115.50.53108467927115.875-7.8754118465932116.51.531125465930116.258.752114464929116.125-2.1253108463927115.875-7.8754117463926115.751.2541124467930116.257.752114466933116.625-2.6253112470936117-54116473943117.875-1.87551128211734prescriptionsofeachyear1001051101151201251301234123412341234123412345yearandquarterprescriptionsRawdataTrendc)SeasonalvariationsYear123422.3750.5-7.8751.538.75-2.125-7.8751.2547.75-2.625-5-1.875Total18.875-4.25-20.750.875Average6.2916667-1.4167-6.916670.291667SumofAverages-1.75-1.75-1.75-1.75QuarterCorrectionfactor-0.4375-0.4375-0.4375-0.4375ASV6.7291667-0.9792-6.479170.729167trendchange=117.875-115.6252.25Quarters:11Averagequarterlytrendchange:0.204545Year5SVActualQ16.7291667124.80871Q2-0.9791667117.30492Q3-6.4791667112.00947Q40.7291667119.42235QuarterTrendCalculationTrendValue117.875+0.204545118.079545Fromthedata,wecanknowthenumberofprescriptionsis119.422117.875+2*0.204545117.875+3*0.204545117.875+4*0.204545118.488635118.28409118.69318d)Estimatethenumberofdispensedprescriptionsforquarter4ofyear5canhelptheHealthServicemanagementbudgetforthecostofprescriptionsandalsothenumberofpharmacistsemployed.Maketheforecastmoreexact.