Can you please help me with these problems...

1.The editor-in-chief of a major newspaper has been trying to convince the paper's owner to improve the working conditions in the pressroom. He is convinced that the noise level when the presses are running creates unhealthy levels of tension and anxiety. He recently had a psychologist conduct a test during which press operators were place in room with varying levels of noise and then given a test to measure moods and anxiety levels. The following table shows the index of their degree of arousal or nervousness and the level of noise to which they were exposes (1.0 is low and 10.0 is high)

Noise Level:43126723

Deg of arousal3938161841452538

a.Plot these data using Microsoft Excel.

b.Develop an estimating equation that describe these data.

c.Predict the degree of arousal we might expect when the noise level is 5.

2.An instructor is interested in finding out how the number of patients in OPD on a given day is related to the mean temperature that day. A random sample of 10 days was used for the study. The following data indicate the number of patients appeared (PTA) in OPD and the mean temperature (Temp) for each day.

PTA:8754235689

TEMP10202530404550555960

a.State the dependent (Y) variable and the independent (X) variable.

b.Draw a scatter diagram of these variables. Then verify the pattern using the value of r.

c.Does the relationship between the variables appear to be linear or curvilinear?

d.What type of curve could you draw through the data?

e.What is the logical explanation for the observed relationship?

3.A professor is trying to show his students the importance of quizzes even through 90% of the final grade is determined by exams. He believes that the higher the quiz grade, the higher the final grade. A random sample of 15 students in his class was selected with the data given below.

Q. Average.59927290958789777665974294946291

Fin. Average65847780778180848080698340786590

a.State the dependent (Y) variable and the independent (X) variable.

b.Draw a scatter diagram using Microsoft Excel and then also calculate r (preferably in Excel if possible) and compare the results.

c.Does the professor's belief appear to be justified? Explain your reasoning.

d.How much effect quiz marks have on final grade?

4.The National Institute of Environmental Health Sciences (NIEHS) has been studying the statistical relationships between many different variables and the common cold. One of the variables being examined is the use of facial tissues(X) and the number of days that cold symptoms were exhibited (Y) by seven people over a 12 months period. What relationship if any seems to hold between the two variables? Does this indicate any casual effect?

5.A study by Metro Bus Service on the effect of bus-ticket prices on the number of passengers produced the following results:

Ticket Price:2530354045505560

Pssngrs/100 m800700780660640600620620

a.Plot these data.

b.Develop the estimating equation that best describe these data.

c.How can we ensure that the above model best used for provided data?

d.Predict the number of passengers per 100 miles if the ticket price were 50. Use 95% approximate prediction interval.