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).

Answer 1

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.

1. Conduct a test of independence to determine whether employee health insurance coverage is independent of the size of the company. Use a = .05.

Compute the value of the X ² 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