Lab Assignment $1$

Perform all calculations using Excel. For any calculations, no other source of answers requiring calculations will be permitted. All the answers should automatically appear in the Answer worksheet unless otherwise specified. After calculating answers on the designated worksheet for each problem, if they do not automatically appear in the Answer sheet, Copy and Paste $123($Values$)$ to the Answer sheet without rounding. Do not type values into the Answer sheet that you calculate elsewhere. Rounded numbers are errors. Only the answers given in the shaded cells will be graded$*.$ Answer all of the following questions as Excel formulas not numbers $($i$.$e$.={\displaystyle \underset{?}{\overset{?}{}}}(A2$:$A40)$ instead of the result$/$number only, unless otherwise specified$).$

$[3$ points$]$ Put your student ID and name in the designated shaded cells in the Answer sheet.

Questions

$[15$ points$]$ The worksheet Movies contains data on a list of Movies produced in America: data description is in the textbox of Movies worksheet.

a$.[1$ pt$.]$ How many variables are in the data set $($you can type a number without using cell reference$/[$ormula$)?$

b$.[2$ pts$.]$ How many observations are there in the file $($you need to use an excel function to get full marks$)?$

c$.[1$ pt$.]$ How many categorical variables are there in this sample $($you can type a number without using cell reference$/$formula$)?$

d$.[2$ pts$.]$ What are the entities in this dataset $($type your answer$)?$

e$.[2$ pts$.]$ Which Movie hacthe lowest Production Cost $($use cell reference to get full marks$)?$

f$.[3$ pts$.]$ What is the total Yrofit for the movies from the Action genre? $[$You need to use excel functions and cell referencing to get full marks. Hint: You may find the formula $=$SUMIF$()$ useful; you can get the answer in other ways as well including cell$-$reference and intermediate steps of creating a subsample of the Action genre only in a new worksheet.

g$.[2$ pts$.]$ What is the ${50}^{uh}$ percentile of Length?

h$.[2$ pts$.]$ What is the first quartile of Length?

$[14$ points$]$ Continue within the Movies worksheet. Use Data Analysis ToolPak to obtain the following:

a$.$ pts$.]$ Calculate the 'Summary Statistics' for Profits, Production Cost, and Length; and save the results in the Descriptive worksheet $($you can choose cell A$1$ within the Descriptive worksheet$).$ Two points for deleting the repetitive information and organizing the Summary Statistics table. Copy and paste your Descriptive Statistics results in the Answer sheet beside Q$2\_$a $($you do not need to fill up the entire space$).$

b$.3+1pts$ Create a variance$-$covariance matrix for the quantitative variables using Data Analysis Toolpak. Save the output within the Movies worksheet in cell K$14.$ Paste the covariance matrix in the Answer sheet