Usefulness of Service Provided One to One Con Workshops Information Pa Funding 1 1 1 1 1 1.4 1.1 1 1.58 1.2 1.17 1.58 1.2 1.17 1.63 1.2 1.28 1.67 1.2 1.38 1.67 1.3 1.42 1.67 1.4 1.45 1.75 1.4 1.5 1.75 1.5 1.7 1.75 1.5 1.72 1.83 1.6 1.77 1.83 1.6 1.77 1.83 1.6 1.83 1.92 1.7 1.87 1.92 1.7 1.92 1.96 1.7 1.93 2 1.8 2 2 1.9 2 2 1.9 2.03 2 2 2.07 2.13 2 2.1 2.17 2 2.12 2.21 2 2.13 2.21 2 2.13 2.25 2 2.15 2.33 2 2.15 2.33 2.1 2.2 2.38 2.1 2.25 2.38 2.1 2.38 2.38 2.1 2.43 2.38 2.2 2.45 2.46 2.2 2.47 2.46 2.2 2.48 2.46 2.2 2.5 2.5 2.2 2.5 2.5 2.3 2.57 2.58 2.3 2.58 2.58 2.4 2.63 2.58 2.4 2.65 2.63 2.4 2.68 2.67 2.4 2.68 2.71 2.4 2.68 2.71 2.5 2.73 2.71 2.5 2.75 2.75 2.5 2.75 2.79 2.5 2.77 2.79 2.6 2.82 2.83 2.6 2.85 2.83 2.6 2.87 2.83 2.6 2.87 2.88 2.7 2.87 2.88 2.7 2.88 2.92 2.7 2.9 2.92 2.7 2.92 2.92 2.7 2.92 2.92 2.8 2.98 2.92 2.8 3 2.96 2.8 3 3 2.8 3.03 3 2.8 3.05 3.04 2.9 3.1 3.13 2.9 3.12 3.17 2.9 3.13 3.17 2.9 3.13 3.17 2.9 3.18 3.17 3 3.2 3.21 3 3.2 3.21 3 3.22 3.21 3 3.27 3.25 3 3.27 3.25 3.1 3.3 3.25 3.1 3.33 3.33 3.1 3.33 3.38 3.1 3.35 3.38 3.1 3.37 3.38 3.18 3.37 3.42 3.2 3.37 3.42 3.2 3.37 3.46 3.3 3.4 3.46 Clients Satisfaction with Govenrment after Receiving ConsultIP's Performance 1.0 1.00 1.5 1.23 1.5 1.30 1.5 1.36 1.5 1.38 1.8 1.48 2.0 1.56 2.0 1.60 2.0 1.65 2.0 1.66 2.0 1.74 2.0 1.76 2.0 1.80 2.3 1.86 2.3 1.90 2.3 1.94 2.3 1.96 2.5 2.03 2.5 2.08 2.5 2.10 2.5 2.11 2.5 2.18 2.5 2.19 2.5 2.21 2.5 2.21 2.8 2.28 2.8 2.31 2.8 2.31 2.8 2.36 2.8 2.37 2.8 2.40 2.8 2.42 2.8 2.47 3.0 2.53 3.0 2.54 3.0 2.55 3.0 2.55 3.0 2.61 3.0 2.62 3.0 2.65 3.0 2.67 3.0 2.69 3.0 2.70 3.0 2.70 3.0 2.74 3.0 2.75 3.0 2.76 3.0 2.77 3.0 2.81 3.0 2.82 3.0 2.83 3.0 2.84 3.0 2.86 3.0 2.88 3.0 2.88 3.3 2.95 3.3 2.95 3.3 2.99 3.3 3.00 3.3 3.01 3.3 3.02 3.3 3.04 3.3 3.10 3.3 3.11 3.3 3.11 3.3 3.11 3.3 3.13 3.3 3.19 3.5 3.23 3.5 3.23 3.5 3.26 3.5 3.26 3.5 3.29 3.5 3.32 3.5 3.33 3.5 3.33 3.5 3.34 3.5 3.37 3.5 3.37 3.5 3.38 3.7 3.46 NC's Performance 1.00 1.30 1.38 1.56 1.65 1.74 1.80 1.90 1.96 2.08 2.11 2.19 2.21 2.31 2.36 2.40 2.47 2.54 2.55 2.62 2.67 2.70 2.74 2.76 2.81 2.83 2.86 2.88 2.95 3.00 3.02 3.10 3.11 3.13 3.23 3.26 3.29 3.33 3.34 3.37 3.46 3.50 3.52 3.57 3.58 3.60 3.70 3.71 3.74 3.75 3.78 3.79 3.84 3.93 3.95 3.95 3.99 4.02 4.02 4.09 4.14 4.18 4.20 4.24 4.26 4.35 4.39 4.41 4.47 4.48 4.50 4.51 4.56 4.63 4.67 1.23 1.36 1.48 1.60 1.66 1.76 1.86 1.94 2.03 2.10 2.18 2.21 2.28 2.31 2.37 2.42 2.53 2.55 2.61 2.65 2.69 2.70 2.75 2.77 2.82 2.84 2.88 2.95 2.99 3.01 3.04 3.11 3.11 3.19 3.23 3.26 3.32 3.33 3.37 3.38 3.49 3.50 3.53 3.58 3.58 3.69 3.71 3.71 3.74 3.78 3.79 3.81 3.86 3.95 3.95 3.96 4.00 4.02 4.08 4.13 4.17 4.19 4.23 4.26 4.33 4.35 4.41 4.45 4.47 4.49 4.50 4.54 4.62 4.64 4.70 3.3 3.3 3.3 3.3 3.3 3.4 3.4 3.4 3.4 3.4 3.5 3.5 3.5 3.5 3.5 3.6 3.6 3.6 3.6 3.6 3.6 3.6 3.6 3.7 3.7 3.7 3.7 3.7 3.7 3.7 3.7 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.9 3.9 3.9 3.9 3.9 3.9 4 4 4 4 4 4 4 4.1 4.1 4.1 4.2 4.2 4.2 4.2 4.2 4.2 4.2 4.2 4.25 4.3 4.3 4.3 4.3 4.4 4.4 3.42 3.43 3.43 3.45 3.45 3.47 3.48 3.48 3.5 3.52 3.55 3.55 3.57 3.57 3.58 3.6 3.6 3.62 3.67 3.67 3.67 3.67 3.7 3.75 3.8 3.8 3.83 3.83 3.83 3.85 3.87 3.9 3.92 3.93 3.93 3.93 3.93 3.98 4 4 4.07 4.12 4.13 4.13 4.17 4.17 4.2 4.22 4.22 4.27 4.28 4.28 4.3 4.3 4.3 4.33 4.33 4.38 4.38 4.38 4.38 4.43 4.48 4.5 4.5 4.55 4.6 4.62 4.65 3.5 3.5 3.5 3.58 3.63 3.67 3.67 3.67 3.67 3.71 3.71 3.75 3.75 3.75 3.75 3.75 3.75 3.79 3.83 3.83 3.88 3.88 3.92 3.92 3.92 3.96 4 4 4 4 4 4 4.04 4.08 4.08 4.08 4.08 4.08 4.13 4.17 4.21 4.21 4.21 4.25 4.25 4.29 4.33 4.33 4.33 4.38 4.38 4.42 4.5 4.5 4.54 4.58 4.58 4.58 4.63 4.67 4.67 4.67 4.67 4.67 4.67 4.67 4.67 4.67 4.75 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.8 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.3 4.3 4.3 4.3 4.3 4.3 4.3 4.3 4.3 4.3 4.3 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.8 4.8 4.8 4.8 4.8 4.8 4.8 4.8 4.8 4.8 4.8 4.8 4.8 4.8 4.8 4.8 5.0 5.0 5.0 5.0 5.0 3.49 3.50 3.50 3.52 3.53 3.57 3.58 3.58 3.58 3.60 3.69 3.70 3.71 3.71 3.71 3.74 3.74 3.75 3.78 3.78 3.79 3.79 3.81 3.84 3.86 3.93 3.95 3.95 3.95 3.95 3.96 3.99 4.00 4.02 4.02 4.02 4.08 4.09 4.13 4.14 4.17 4.18 4.19 4.20 4.23 4.24 4.26 4.26 4.33 4.35 4.35 4.39 4.41 4.41 4.45 4.47 4.47 4.48 4.49 4.50 4.50 4.51 4.54 4.56 4.62 4.63 4.64 4.67 4.70 Aiming to boost the economy within rural areas of Ontario, the government invested on a new initiative, named Canada Rural Partnership (CRP). Two consultancies won the bid to undertake this project: Innovation Pursuit (IP) and North Consultancy (NC). IP supported far northern communities and NC supported rural areas. IP and NC's goal were to: Initiate collaboration between rural communities and stakeholders to address barriers and challenges to local development Prepare information and tools used by rural communities and regions to develop local amenities and other assets Initiate new economic activities in rural Canada During four years they provided advice to 653 clients. At this point of time the government of Ontario is evaluating CRP's effectiveness. They would like to know the following based on a sample of 150 companies. 1. Clients who participated in this program were asked to identify their level of satisfaction with the government prior to receiving consultation; this showed a mean of <3. The government of Ontario likes to know whether their opinion has risen to more than 3 after the consultation with 5% significance. 2. Clients were provided with 1) one to one consultation, 2) workshops and 3) information packages 4) Funding. The government of Ontario is interested to know which one of these methods were deemed most useful by clients, analyze (hint: compare mean with 95% confidence). 3. Some of the employees of the Ontario government believe that IP performed better than NC. In the selected sample IP provided advice to 75 companies and NC to the rest of the 75 companies. Did IP really performed better than NC? Directions: - Answer each questions on a separate Excel Sheet. - Analysis: For each question propose hypothesis, justify the selected method of analysis, discuss test requirements and present the test results in tables. - For each question discuss the findings of the study, what do they mean? how can they help in decision making? 1