Question

Before taking the plunge into videoconferencing, a company ran tests of its current internal computer network. The goal of the tests was to measure how rapidly data moved through the network given the current demand on the network. Twenty files ranging in size from 20 to 100 megabytes (MB) were transmitted over the network at various times of day, and the time to send the files in seconds) recorded. Complete parts a through f below. Click the icon to view the data table. (a) Create a scatterplot of Transfer Time on File Size. Does a line seem to you to be a good summary of the association between these variables? Construct the scatterplot. Choose the correct graph below. . . File Size (MB) Transfer Time (sec) File Size (MB) Transfer Time (c) . i.. 2014 Transfer Time (sec) 20 60 1061 File Size (MB) 2016 Transfer Time (sec) 2060 File (MB) Does a line seem to you to be a good summary of the association between these variables? O A. Yes, because the scatterplot does not show any obvious pattern OB. No, because the scatterplot shows an obvious curved line. c. Yes, because the scatterplot shows an approximate linear pattern. OD. No, because the scatterplot does not show any obvious pattern.

(Just need help with part F)

File_size_(MB) Time_(sec)

77 31.1

93 35.1

85 35.3

94 35.7

20 14.4

74 28.9

68 29.6

88 33.5

42 21.7

20 15.3

72 28.4

24 11.5

95 35.7

59 25.6

93 36.6

71 29.1

87 34.3

92 37.2

90 35.6

67 26.8

87 32.6

83 31.2

80 34.1

57 22.8

52 25.4

76 28.9

96 38.7

70 31.8

59 24.2

57 28.1

Answer 1

* Please give positive rating- Estimated transtor tinel second) = 7.599 + 0.292 ob (from past 8) (Filesizeme 15 = 7.599 8. 292xx 15- 7.599 292 X2 25.346 (MB) tile size (in mB) por 15 Becord transfer tine. so equation given in parte in useful to solve this que. or part (f).

2. Peres se regression fike tile Size (MB) A = 7.599 + 292 Ctime tronsted) - 7.599+ 292x15 - 11.980 inter Changed the deperdent Variable and the independent Variable inreverse regresoon method.)

Answer 2

Solution part F:

Perform regression in excel

File Home Insert Page Layout Formulas Data Colectica Review View Help Tell me what you want to do Clear Reapply Advanced External Data Connections e Properties Refresh All Edit Links Connections Stocks Geography Sort From From From SPSS Stata SAS Get Statistical Data Filter New Query - LO Get & Transform Data Types Sort & Filter Regression Input Input Y Range: ок Cancel i was in Input X Range: 1 $A$1:$A$311 SBS1:5B5311 Constant is Zero 95 % Help Labels Confidence Level: 35.67 32.6 31.2 Output options O Output Range: O New Worksheet Ply: O New Workbook Residuals N Pariduals 34.1 Paridual plots

we get

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.97208
R Square	0.94494
Adjusted R Square	0.942973
Standard Error	5.267833
Observations	30
ANOVA
	df	SS	MS	F	Significance F
Regression	1	13334.86	13334.86	480.5346	3.61E-19
Residual	28	777.0018	27.75006
Total	29	14111.87
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	-20.0454	4.260264	-4.70521	6.21E-05	-28.7722	-11.3187
Time_(sec)-(x)	3.104371	0.141616	21.9211	3.61E-19	2.814284	3.394457

ANSWER:

regression eq i

y=-20.0454+3.104371*x

Filesize=-20.0454+3.104371*time

For x=15 we need to predict y

we get

Filesize=-20.0454+3.104371*time

=-20.0454+3.104371*15

= 26.52016

ANSWER:

(B)

Do the regression in reverse and use the new fitted line.The estimated file size is 26.52 Mb