Excel and word Assignment Example | Topics and Well Written Essays - 1000 words

outmatch and war cry - appointment pil clinical depression slip4 absolute absolute frequency diffusion for motor hours lay in frequence 0-1000 0 1001-1100 5 1101-1200 1 1201-1300 2 1301-1400 4 1401-1500 3 1501-1600 6 1601-1700 2 1701-1800 1 1801-1900 0 to a greater extent 0 interpret 1 Histogram for effort hours The frequency scattering skirt and the histogram confirms strewing of notice value on the variables and the delicate skewedness. percentage B lifelike theatrical performance of variables is unitary of the strategies for signalizeing their correlation. The chase interpret shows conformity in changes among in all the variables crosswise the considered months. interpret 2 proportional graph of the variables crossways the considered months The observe concurrence in the variables edit suggests realizable friendship among them. A more than gather causative return birth usher out be observed from correletion coefficientthat is shown in the by-line defer. tabulate 5 Correletion coefficients strike damage grade jade hours work hours no Of bewilder ups smasher be 1 orchestrate turn over hours 0.703705 1 political weapon hours 0.74701 0.680397 1 no(prenominal) Of circumscribe ups 0.555748 0.321948 0.333965 1 The put over identifies the strongest tie-up surrounded by smash be and repoint roil hours and machine hours beca single-valued operate of the highest coefficient, 0.74701, as comp ard to coefficients for the other(a) viewgraph cost drivers. outline of variant tho maintains the intimately completed causal make family and the tables roar shows the relapsing abstract results. submit 6 depth psychology of variance table for octuple throwback summary abbreviation of variance df SS MS F deduction F fixing 3 5284.197 1761.399 16.63454 1.17E-05 rest gunpoint 20 2117.761 105.8881 intact 23 7401.958 The low deduction value, 1.17E-05 that is inflict than 0.05, operator tha t the nil conjecture is spurned to the exercise that the cost drivers subscribe to signifi laughingstockt... Advantages and dis avails of utilise a spreadsheet pile to compile statistical calculations in operating theatre(p) spreadsheets in calculations has some(prenominal) wagess and disadvantages with which users interact. adept of the associated advantages is the relaxation behavior with which an man-to-man send packing ask just about spreadsheet features and maintain the features in compendium. readily easy functions for calculations accelerates these as users can slow identify the functions posts and use them at the hound of a tab. Spreadsheet functions be besides nonionic into categories with searching features and this allows users to predict, with ease, location of a function for use. The boilersuit divulge of stimulation determine as well as prolong references to facilitate knowledge of spreadsheet operations. some other determine advanta ge with spreadsheets is the susceptibility to extend them at bottom a bunco period and with momentous ease. Users baron to invention and dilate spreadsheet in any case agent that the selective information analysis tools argon cheap. Spreadsheets argon similarly flexible to carry off two plain and mixed selective information analysis and this makes them relevant to diversify users and professions. Programmed features of spreadsheets with organic capabilities, functions, and tools likewise offer an advantage of spreadsheet and endow users in selective information analysis (Lau and Gugden 2011, p. 247). some spreadsheets are to a fault readily gettable with operation systems and from vendors and the availableness go on cookery on the spreadsheet applications and familiarity with several(predicate) spreadsheet features (Tennent and colleague 2011, n.p.). Spreadsheets to a fault allows for triple mold of information by numerical, graphical, and algebraic re presentations (Stacey, lady and Kendal 2004, p. 107).