Instruction $($read before start$)$:

$($a$)$ Chapter $14.$

$($b$)20$ points for each question $1$a$,1$b$,1$c$,1$d$,1$e; $100$ points total.

$($c$)$ No credits will be given if Excel work are not submitted for each question. Answer the questions in Word, as well as$,$ show the Excel functions and results in Excel. Attach both Word and Excel practice files when submitting the Excel practice on Blackboard. Your Excel work must show the Excel functions, tables and charts you use to get the Excel practice answers. $$

$$

$1($Chapter $14).$ As a customer service analyst for a copier machine company, you are requested by the manager to conduct a simple linear regression analysis for the relationship between the number of copiers $($x$)$ and the copier service time $($y$).$

$($a$)$ Write the simple linear regression equation below.

$$

$$

$($b$)$ What are b$0$ and b$1?$

$$

$$

$($c$)$ Interpret the managerial meanings of b$0$ and b$1.$

$$

$$

$($d$)$ If the number of copiers $($x$)$ is $15,$ what will the copier service time $($y$)$ be$,$ using the simple linear regression model $1$a$?$

$$

$$

$($e$)$ Draw the scatter chart showing the relationship between the number of copiers $($x$)$ and the copier ser

Copier Service Time Data Copiers X Minutes Y $4109258513871891373824103513426841126154$