This document discusses the application of pivot table in analyzing data sets. It also explores the importance of social media on teens and the functions of Excel's pivot table. The document provides insights into average purchases across regions, types of payment, purchasing time, and average sales price.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
Running head:APPLICATION OF PIVOT TABLE Application of Pivot Table Name of the Student: Name of the University: Author Note:
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
2APPLICATION OF PIVOT TABLE PART-I Answer 1. Fig ure 1: Important Social Media Sites for Teens (Reproduced Graph). The graph shows the percentage of importance of social networking sites on teens. The graph is a clustered bar chart. In the figure above, the social networking sites, Facebook, Twitter, Instagram, Google, Tumbir, Pinterest and other are on the vertical axis of the graph and the horizontal axis represents the percentage of importance of social networking sites. There are three bars for each social networking sites representing three seasons: fall 2012, spring 2013 and fall 2013. Answer 2. Young people are mostly using the social media as a medium of communication, interaction and sharing information. There is a rapid increase in the use of social media among young children and teenagers with the potential effect on success. There is a wide
3APPLICATION OF PIVOT TABLE range of social networking sites and the important and globally used social networking sites are Facebook, Instagram, google, Tumbir and Pinterest. There are positive impacts of social media on teenagers like social media provides help and support at hard times, it empowers the girls to express their thoughts and things they value and most importantly it connects them with their friends easily(Seo, Houston, Knight, Kennedy & Inglish, 2014.). Social media plays a role to the teenagers to spread social awareness, to access educational benefits throughdiscussion,toenhancetheirskills,toenhancecreativity,confidenceand independence. Now the figure 1 shows the importance of social media on teens in fall 2012, spring 2013 and fall 2013. The most Facebook have the greater importance on teens among other social website in fall 2012 and spring 2013. In fall 2013, Twitter becomes topper at the list of social website having importance on teens. The whole picture depicts that the growth of other social media sites except Facebook, Instagram, google, tumber and Pinterest have a huge growth in fall 2013. In fall 2013, the importance of Facebook, twitter and Instagram has almost same level of importance on teens in the social world. Though, the importance of Google and Facebook is falling compared to the other existing social websites as shown in the figure 1. Where the importance of Instagram is growing in opposite of Facebook and google. Instagram is a platform where one can showcase their photography and videography skills and also can share with the world. This platform has unique presentation mode which is visual rather descriptive. This can play a major role in spreading the awareness of relative skills among the people roaming around the social websites. This can enhance the relative skills and can bring the relative opportunities to the young people of the society. This is also being used in the online education process by making videos on various subjects like social,
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
4APPLICATION OF PIVOT TABLE cultural and also study materials of various subjects offered in renowned universities from all over the world. PART-II This part mainly focuses on the functions of Excel’s Pivot Table to analyse a data set. Now the below tables are the application of pivot table on the data set which is a list of sales transactions at OMT for one day (Jelen & Alexander, 2015). Answer 1. Table 2: Average purchases across the region. Row LabelsAverage of Amount East41.86 North32.48 South42.94 West38.08 Grand Total38.83 The above table shows the average purchases of different regions. The highest average purchase is in the south region and the average purchase is $42.94. The lowest average purchase is in the north region and the average purchase is $32.48. From this, it is easy to say that the north region has been suffering from sales recourse scarcity and poor marketing strategy. Whereas, the south region has been getting these treatments wells. Now, it is simple to say that north needs the manager’s focus for marketing and sales resources. Along with north, west also needs focus on marketing and sales resources. However, average amount of purchase in west is not as low as in north. Answer 2. Table 3: percentage of types of payment out of total purchase Row LabelsCount of PaymentCount of Payment 2 Credit32263.14%
5APPLICATION OF PIVOT TABLE PayPal18836.86% Grand Total510100.00% The table 3 shows the percentage of payment types which is followed by the market. Out of total population, 63.14% people are using the credit for purchasing and 36.86% people are purchasing through PayPal. The number of purchases by people using PayPal is less than the half of purchases by the people using credit as a mode of purchase. It simply shows that the people preferred to purchase through credit. Now, advertisement of payment through credit can have a great impact on purchases. It can potentially increase the amount of purchases. Answer 3. Table 4: Percentage of Purchasing at a particular time of day out of total purchase Row LabelsCount of Purchasing TimeCount of Purchasing Time2 Home28155.10% Work22944.90% Grand Total510100.00% The table 4 represents the percentage for people’s purchases during the day and in the evening. The table shows that the people are most likely to purchase from home in the evening. 44.9% people purchases during the day when they are at work and 55.1% people do the purchasing in the evening when they are at home. Answer 4. Table 5: Relationship between regions, type of product purchased and average sales price Average of AmountColumn Labels Row LabelsBookOnlineGrand Total East59.3419.2241.86 North42.9620.0032.48 South58.1319.8042.94 West54.1619.8838.08
6APPLICATION OF PIVOT TABLE Grand Total54.1219.7638.83 The above table represents the average sales price for product, Book and Online across the regions. It shows that the average sales price for book is higher than the online. Except north. the average price for book is almost three times higher than the average price of online and for north, the average price for book is almost double than the average online price. It shows the demand for online is quite high in the north than the
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
7APPLICATION OF PIVOT TABLE Reference: Jelen, B., & Alexande, M. (2015).Excel 2016 Pivot Table Data Crunching. Que Publishing. Seo, H., Houston, J. B., Knight, L. A. T., Kennedy, E. J., & Inglish, A. B. (2014). Teens’ social media use and collective action.new media & society,16(6), 883-902.