Please use python.
Step a: Create two DataFrames df1 and df2 from the following two tables that hold student scores. Each DataFrame has four rows and three columns.

Step b: Join the two DataFrames into df3 so that it only includes the students who appear in both tables. Print df3.

Step c: Set the column 'Name' as the index of df3 using df3.set_index() function. Print the updated df3. You can learn from https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.set_index.html.

Step d: Show the average score of each student in df3.

Do you take the free samples offered in supermarkets? About 58% of all customers will take free samples. Furthermore, of those who take the free samples, about 32% will buy what they have sampled. Suppose you set up a counter in a supermarket offering free samples of a new product. The day you were offering free samples, 309 customers passed by your counter. (Round your answers to four decimal places.)

(a) What is the probability that more than 180 will take your free sample?

(b) What is the probability that fewer than 200 will take your free sample?

(c) What is the probability that a customer will take a free sample and buy the product? Hint: Use the multiplication rule for dependent events. Notice that we are given the conditional probability P(buy|sample) = 0.32, while P(sample) = 0.58.

(d) What is the probability that between 60 and 80 customers will take the free sample and buy the product? Hint: Use the probability of success calculated in part (c).

3. A quality survey asked recent customers of their experience at a local department store. One question asked for the customers rating on their service using categorical responses of average, outstanding, and exceptional. Another question asked for the applicant’s education level with categorical responses of Some HS, HS Grad, Some College, and College Grad. The sample data below are for 700 customers who recently visited the department store.

Using a level of significance of 0.01, is there evidence to suggest that the customer’s Education level and Quality Rating are independent? In other words, is there a relationship or is there NO relationship between Education and Quality Rating?

1. State the Null and Alternative hypothesis.

2. What is the statistic you would use to analyze this?

3. State your decision rule:

4. Show your calculation:

5. What is your conclusion?

Quality Rating and Education level are independent

OR

Quality Rating and Education level are NOT independent

The following question presents hypothetical data concerning transfer of cotton between departments as part of the Cotton On Group's production processes. The textile department produces cotton for use by various other production departments within the Cotton On Group. The costs incurred by the textile department to produce cotton are provided below:

The textile department can also sell cotton to external customers for $5.00 per square metre. Sales staff from the textile department are paid a sales commission of $0.10 per square metre for sales to external customers. No sales commissions are paid for transfers to internal customers.

Required

1. Measure and discuss the internal transfer price for cotton if the general transfer price rule is used in the following situations:
   1. The textile department has infinite capacity .
   2. The textile department has no spare capacity .
   3. The textile department has capacity to produce 50,000 metres, internal demand is 40,000 metres and external demand is 17,000 metres .

A quality survey asked recent customers of their experience at a local department store. One question asked for the customers rating on their service using categorical responses of average, outstanding, and exceptional. Another question asked for the applicant’s education level with categorical responses of Some HS, HS Grad, Some College, and College Grad. The sample data below are for 700 customers who recently visited the department store. Education Quality Rating Some HS HS Grad Some College College Grad Average 55 80 50 35 Outstanding 60 105 65 70 Exceptional 35 65 35 45 Using a level of significance of 0.01, is there evidence to suggest that the customer’s Education level and Quality Rating are independent? In other words, is there a relationship or is there NO relationship between Education and Quality Rating? a. State the Null and Alternative hypothesis. b. What is the statistic you would use to analyze this? c. State your decision rule: d. Show your calculation: e. What is your conclusion? Quality Rating and Education level are independent OR Quality Rating and Education level are NOT independent

. A quality survey asked recent customers of their experience at a local department store. One question asked for the customers rating on their service using categorical responses of average, outstanding, and exceptional. Another question asked for the applicant’s education level with categorical responses of Some HS, HS Grad, Some College, and College Grad. The sample data below are for 700 customers who recently visited the department store. Education Quality Rating Some HS HS Grad Some College College Grad Average 55 80 50 35 Outstanding 60 105 65 70 Exceptional 35 65 35 45 Using a level of significance of 0.01, is there evidence to suggest that the customer’s Education level and Quality Rating are independent? In other words, is there a relationship or is there NO relationship between Education and Quality Rating? a. State the Null and Alternative hypothesis. b. What is the statistic you would use to analyze this? c. State your decision rule: d. Show your calculation: e. What is your conclusion? Quality Rating and Education level are independent OR Quality Rating and Education level are NOT independent

2 A. What is the natural rate of Unemployment? What are the causes of this kind of Unemployment? Describe any one of the causes of natural rate of unemployment in detail.

2 B. (GRAPH IS MANDATORY) You can upload the graph as a file (Draw the graph/Take a picture)

3. RESPONSE (T OR F) AND CORRECT EXPLANATION.

(a) Malthus was pessimistic about nations’ economic growth.

(b) French riots in March 2006 happened due to reform in International Trade laws.

an educational psychologist wishes to know the mean number of words a third grader can read per minute. She wants to make an estimate at the 99% level confidence. For a sample of 2006 third graders, the mean words per minute read was 27.2. assume a population standard deviation of 4.1. construct the confidence interval for the mean number of words a third grader can read per minute. Round your answer to one decimal place.

an educational psychologist wishes to know the mean number of words a third grader can read per minute. She wants to make an estimate at the 99% level confidence. For a sample of 2006 third graders, the mean words per minute read was 27.2. assume a population standard deviation of 4.1. construct the confidence interval for the mean number of words a third grader can read per minute. Round your answer to one decimal place.