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

Excel and word - Assignment Example 4: Frequency distribution for labour hours Bin Frequency 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 More 0 Graph 1: Histogram for labour hours The frequency distribution table and the histogram confirms dispersion of observed values on the variables and the slight skewedness. Section B Graphical representation of variables is one of the strategies for identifying their correlation. The following graph shows consistency in changes among all the variables across the considered months. Graph 2: Comparative graph of the variables across the considered months The observed consistency in the variables’ trend suggests possible association among them. A more clear causal effect relationship can be observed from correletion coefficientthat is shown in the following table. Table 5: Correletion coefficients    Overhead costs Direct labour hours Machine hours No. Of set ups Overhead costs 1 Direct labour hours 0.7 03705 1 Machine hours 0.74701 0.680397 1 No. Of set ups 0.555748 0.321948 0.333965 1 The table identifies the strongest association between overhead costs and direct labor hours and machine hours because of the highest coefficient, 0.74701, as compared to coefficients for the other overhead cost drivers. Analysis of variance however offers the most accurate causal effects relationship and the tables bellow shows the regression analysis results. Table 6: ANOVA table for multiple regression analysis ANOVA    df SS MS F Significance F Regression 3 5284.197 1761.399 16.63454 1.17E-05 Residual 20 2117.761 105.8881 Total 23 7401.958          The low significance value, 1.17E-05 that is lower than 0.05, means that the null hypothesis is rejected to the effect that the cost drivers have significant... Advantages and disadvantages of using a spreadsheet package to compile statistical calculations Operating spreadsheets in calculations has both advantages and disadvantages with which users interact. One of the associated advantages is the ease with which an individual can learn about spreadsheet features and apply the features in analysis. Readily available functions for calculations facilitates these as users can easily identify the functions’ locations and use them at the click of a tab. Spreadsheet functions are also organized into categories with distinct features and this allows users to predict, with ease, location of a function for use. The overall display of input values also offer references to facilitate learning of spreadsheet operations. Another identified advantage with spreadsheets is the ability to develop them within a short period and with significant ease. Users’ ability to design and develop spreadsheet also means that the data analysis tools are cheap. Spreadsheets are also flexible to handle both simple and complex data analysis and this make s them applicable to diversified users and professions. Programmed features of spreadsheets with â€Å"built-in capabilities, functions, and tools† also offer an advantage of spreadsheet and empower users in data analysis (Lau and Gugden 2011, p. 247). Most spreadsheets are also readily available with operation systems and from vendors and the accessibility promote training on the spreadsheet applications and familiarity with different spreadsheet features (Tennent and Friend 2011, n.p.). Spreadsheets also allows for multiple representation of data through â€Å"numerical, graphical, and algebraic representations† (Stacey, Chick and Kendal 2004, p. 107).

Use of social networks for financial and performance reporting Research Paper

Use of social networks for financial and performance reporting - Research Paper Example This research analyses how the financial reporting and organizations performance have improved for the past few years because of increased use of social networking. Inescapabilty and popularity of the social network has largely created awareness and improved the relationship between the business and the stakeholders by introducing a new way in which financial information is disseminated and eventually consumed. Companies primarily use the social media to report their performances so that the information can reach larger audience who may be interested. Information that was previously released in news releases, conference calls and presentations are revealed through twitter because of its ability to swiftly and efficiently receive and share information from a trusted source. There are live tweets of companies’ earning call enabling shareholders who are physically absent during call to receive live information. According to Scott (2013), â€Å"Of Facebook’s nearly one billion strong users, approximately 200 million are mobile only.† On the other hand, YouTube, and Flickr may be utilized in providing videos regarding earning calls, do presentations thus engaging investors with the business financial reports as well as sharing information such as crucial business transactions that include merger and acquisition. It is worth noting that the social network has the ability to reach even remote communities thus enabling the company to operate in distant and remote places while raising awareness about them. There are many reasons justifying the use of social media in financial reporting and performance. Social media’s ability to reach a huge audience makes it the best communication channels for businesses compared to the conventional methods that are inaccessible to some people. According to Scott (2013), â€Å"Statistical research has revealed that more than 95 per cent of  Facebook users log into their account every day. The same number