Consider a small sized company that is interested in setting up a network for th
ID: 2304775 • Letter: C
Question
Consider a small sized company that is interested in setting up a network for their business. The company has a total of 350 employees: 250 employees are located on five floors of the HQ building based in Chicago, and the other 100 employees are located on two floors in a building in Seattle. The two sites are connected using a WAN link. Each employee has a desktop and an IP phone on their desk. In each office (building), there are four servers, the first for engineering development, the second for manufacturing, the third for the company’s external website, and the fourth for management, sales, marketing, and personnel databases. The servers in the Seattle office are backup servers for the servers in the Chicago HQ; if any server fails in HQ, its functionality fails over to the corresponding server in Seattle. There should be three LANs, one for the engineering department, one for manufacturing department, and one for marketing and administration. The engineering department has 200 employees in total (150 in Chicago, 50 in Seattle), and its LAN hosts the engineering development server. The manufacturing department has 100 employees in total (70 HQ, 30 Seattle), and its LAN hosts the manufacturing server. The last LAN hosts the remaining two servers, and has 30 employees in Chicago and 20 employees in Seattle. All these LANs are wired LANs. Additionally, the Chicago office has a guest WLAN that can serve up to 63 connections, while the Seattle office has a guest WLAN which serves up to 30 connections. The company has been assigned the IP address range 216.244.168.0 to 216.244.175.255. The IP addresses 216.244.175.254 and 216.244.175.253 are reserved for the two end points of the WAN link.
1. Describe the networking requirements for this company as a Network Administrator.
2. Design a network and specify the IP address range for each LAN/WLAN.
3. Suppose an engineer in HQ opens a telnet session with the engineering development server (in HQ). Describe in detail the traffic flow.
4. Suppose an engineer in HQ pings the manufacturing server in the manufacturing LAN in HQ. Describe in detail the traffic flow.
5. Suppose an engineer in HQ pings the manufacturing server in the manufacturing LAN in Seattle. Describe in detail the traffic flow.
6. Write down the routing table of the router to which the engineering LAN is connected to in HQ. The routing information in this table should ensure network-wide IP connectivity between any pair of hosts. The table should include these fields: destination network address, netmask, next hop address/outgoing interface, hop count to destination (including the destination subnet).
Explanation / Answer
With double-digit annual percentage increases in the cost of health insurance, more and more workers are likely to lack health insurance coverage (USA Today, January 23, 2004). The following sample data provide a comparison of workers with and without health insurance coverage for small, medium, and large companies. For the purposes of this study, small companies are companies that have fewer than 100 employees. Medium companies have 100 to 999 employees, and large companies have 1000 or more employees. Sample data are reported for 50 employees of small companies, 75 employees of medium companies, and 100 employees of large companies.
Compute the value of the X 2 test statistic (to 2 decimals): 3.91 .
The p-value is 0.1413. What is your conclusion?
Do not reject the null hypothesis because P=0.1413 > 0.05 level of significance.
- Select your answer –
Conclude health insurance coverage is not independent of the size of the company
Cannot reject the assumption that health insurance coverage and size of the company are independent
b) The USA Today article indicated employees of small companies are more likely to lack health insurance coverage. Calculate the percentages of employees without health insurance based on company size (to the nearest whole number).
Small= 20%
Medium= 9 %
Large= 10%
c) Based on the percentages calculated above, what can you conclude?
Based on company size percentages, employees of small companies are more likely to lack health insurance coverage.
Chi-Square Test
Observed Frequencies
Column variable
Calculations
Size of company
Yes
No
Total
fo-fe
Small
40
10
50
-4
4
Medium
68
7
75
2
-2
Large
90
10
100
2
-2
Total
198
27
225
Expected Frequencies
Column variable
Size of company
Yes
No
Total
(fo-fe)^2/fe
Small
44
6
50
0.3636
2.6667
Medium
66
9
75
0.0606
0.4444
Large
88
12
100
0.0455
0.3333
Total
198
27
225
Data
Level of Significance
0.05
Number of Rows
3
Number of Columns
2
Degrees of Freedom
2
Results
Critical Value
5.991465
Chi-Square Test Statistic
3.914141
p-Value
0.1413
Do not reject the null hypothesis
Chi-Square Test
Observed Frequencies
Column variable
Calculations
Size of company
Yes
No
Total
fo-fe
Small
40
10
50
-4
4
Medium
68
7
75
2
-2
Large
90
10
100
2
-2
Total
198
27
225
Expected Frequencies
Column variable
Size of company
Yes
No
Total
(fo-fe)^2/fe
Small
44
6
50
0.3636
2.6667
Medium
66
9
75
0.0606
0.4444
Large
88
12
100
0.0455
0.3333
Total
198
27
225
Data
Level of Significance
0.05
Number of Rows
3
Number of Columns
2
Degrees of Freedom
2
Results
Critical Value
5.991465
Chi-Square Test Statistic
3.914141
p-Value
0.1413
Do not reject the null hypothesis