A bank loaned out $66000, part of it at 9% per year and the rest at 4% per year. If the interest received was $4190, how much was loaned at 9%?

You will submit one Word document for this assignment. You will create this Word document by cutting and pasting SPSS output into Word and naming the file johnsoncPSY7107-5.doc Begin by downloading the following SPSS data sets:Downloadfestival.savChickflick.savHiccups.savTextmessages.savExamAnxiety.savPart A. Creating Visual Displays of Data. For this assignment, you will copy and paste output you created while working in Chapter 4 into a Word document. Please read the instructions below to ensure you are pasting the correct material into your assignment (This chapter has you create many charts and not all are required for this assignment).Using the data set: DownloadFestival.sav, calculate the mean, standard deviation, and minimum and maximum values for the variable Day1. You should notice that there is an outlier for this variable and you should change the value of the outlier you have identified to 2.02. Next, you will create a boxplot for males and females for the Day1 variable. Be sure to save the data set with a new name, indicating it is the corrected data set (outlier identified and corrected). Save this boxplot, with an appropriate title in your assignment document. Using the data set: Chick-Flick.sav, create a simple bar chart for independent means. The variables you will use are: Arousal, Film, and Gender (grouping variable). Be sure to display error bars and save your chart with an appropriate title in your assignment document.Using the data set: Hiccups.sav, create a bar chart for related means. The variables you will use are: Baseline, Tongue Pulling, Carotid Artery Massage, Digital Rectal Massage. Be sure to display error bars, include labels for the X- and Y-axis, and save your chart with an appropriate title in your assignment document.Using the data set: Text Messages.sav (note: you may see an additional data set with the same name: TextMessages.sav – either will create the correct output), create a clustered bar chart for mixed designs. The variables you will use are: Time1, Time2, and Group. Be sure to display error bars, include labels for the X- and Y-axis, and save your chart with an appropriate title in your assignment document.Using the data set: Exam Anxiety.sav, create a scatterplot that includes a regression line. The variables you will use are: Exam Performance and Exam Anxiety. Be sure to include the regression line and save your chart with an appropriate title in your assignment document.Part B. Why Exploratory Data Analysis? Write a short paragraph that highlights your understanding of why exploratory data analysis is a critical part of any analytical strategy (300-500 words). You should support your answer to this question by citing and referencing the course materials or other scholarly resources. This answer is worth 5 points (half the assigned points for this assignment). To receive full credit you must show a high level of understanding the importance of exploring data visually. You should now have the following file:lastnamefirstinitialPSY7107-5.doc