Activity I - You have just opened a restaurant in a large city, and you are deciding what you should charge for a regular-sized soda. You'd like to charge a price equal to the average of your competitors, which you believe is $2.58. To inform your decision, you want to learn more about the average price charged by competing restaurants in the area. You know you won't be able to get prices for every restaurant, so you randomly sample 35 and collect their soda prices. These data are in Soda.xlsx (See the attached) You are assuming the mean soda price is $2.58 for all of your competitors. When conducting data analysis to test this belief, what is this assumption called?Calculate the t-statistic assuming the mean soda price for all of your competitors is $2.58.Calculate the p-value for your t-statistic.Using a confidence level of 90%, test whether the mean soda price of all your competitors is $2.58 using the t-stat.Using a confidence level of 90%, test whether the mean soda price of all your competitors is $2.58 using the p-value.Is it possible that your answers to parts d and e would yield different conclusions? Activity II - To better assess your willingness-to-pay for advertising on others’ websites, you want to learn the mean profit per visit for all visits to your website. To accomplish this, you have collected a random sample of 4,738 visits to your website over the past six months. This sample includes information on visit duration and profits. The data are contained in WebProfits.xlsx (See the attached) Using the data in WebProfits.xlsx: Build a 99% confidence interval for the mean profit per visit for all of your visitors.Let the null hypothesis be that mean profit per visit for all of your visitors is $11.50.Calculate the corresponding t-stat for this null hypothesis.Calculate the corresponding p-value for this null hypothesis.With strength of 95%, decide whether or not to reject this null hypothesis.Detail the reasoning behind your decision.need answer with calcs for activity I and II

We began our discussion of difference, stereotyping, and prejudice by viewing Pleasantville. In a well-written essay, apply the theories and research discussed in this series of lectures to illustrate a more sophisticated understanding of the events in the film. As discussed in class, an understanding of the social and group dynamics evident in Pleasantville begins with an understanding of the challenges posed by difference, like those introduced in Pleasantville. We discussed seven points that describe what is challenging about difference in lecture. How do you see these points illustrated in Pleasantville? Be sure to use specific examples to support your claims. As you explicate these seven points identify three to four theories of blatant and subtle stereotyping and ideologies embodied in the steps. You can discuss more theories if they will help you to improve your response. What conclusions from your analysis can you draw about how difference is manipulated and exploited in your daily life? For example, how does the media exploit social differences? How are these differences exploited in politics? Do you have a personal example to share about how differences are exploited? Your response should be detailed and thorough. 6 pagesAssume that our understanding of “self” is ONE among several types of cognitive structures that constitute our entire memory (e.g., we also have role schemas, person schemas, scripts, collective forms of memory, etc.). Also assume that the “self” (self-schemata) is a central cognitive structure that organizes all other cognitive structures in memory. Develop an explanation for how the “self” structures and organizes all other cognitive structures. Be sure that your explanation describes WHY the self is this central cognitive structure. As you develop these explanations you should describe your view of the “self” by incorporating the many perspectives discussed in class (e.g., the ideal self, feared self, possible self, etc.). Your explanation should draw on material from Fiske and Taylor and class discussions (including Cognitive Experiential Self Theory and our discussion of schemas prior to the midterm). Your explanation will be your own theory of the way memory works. Describe how your explanation of human memory is related to one or more of the forms of communication we discussed this semester. 6 pages