1. Facebook Metrics: The file FacebookMetrics.sav contains (a subset of) data from a real-life data set1 from a cosmetic company's Facebook page. The data consists of 2 metrics about 500 Facebook posts made by a worldwide renowned cosmetics company between January 1, 2014 and December 31,20142. Each row in the dataset corresponds to a Facebook post made by the cosmetics company. The following variables are captured in the dataset (definitions are provided in the 'Labels' and 'Values' columns as well). (28 points) 1. Run the appropriate analysis to investigate how the metric 'Total Interactions' vary depending on the post category and whether the post was paid or not

category of post. There are three post categories coded in the following manner

1: "Action: Special Offers and Contests",

2: "Product: Direct Advertisement & Explicit Brand Content"

3: "Inspiration: Non-Explicit Brand Related Content"

Payment Status: Whether a post made by the company was paid or not. The following coding scheme is used

0: Unpaid

1: Paid

Total Interaction: Sum of likes, shares, and comments on a post

All relevant output for this should be saved in a SPSS viewer file <.spv.

Note: You can use the 'Edit > Copy ' menu to copy contents from one .spv file, then use 'Edit > Paste After' to paste to another .spv file

If you use Excel for any part of this problem, please perform all analysis in Sheet2 of <.xlsx.

a. How many of each category was posted in the year?

b. How many posts were paid/unpaid?

c. What is the average interaction for each content category? What are the standard deviations?

d. What is the average interaction for paid vs unpaid posts? What are the standard deviations?

2. Run the appropriate statistical analysis to test whether 'Total Interactions' vary depending on the category of post and whether the post was Paid or not (0: unpaid, 1: paid).

a. Does post Category matter?

b. Does Payment Status Matter?

c. Is there an Interaction between post category and payment status? What is the meaning of this interaction

d. Create a visualization for the average Interaction based on Payment status and category. You may put the payment status on the X axis and show multiple lines representing the average interaction for each post category. Be prepared to answer questions based on the visualization.

Please give me a step to step explaination o how I can solve this in SSPS or excel. I do not have a way to upload the data set here.