PPT - Snowflake Data Engineering with DBT| Online Training Visualpath PowerPoint Presentation

Snowflake Data Engineering with DBT| Online Training Visualpath

Nov 01, 2025

0 likes | 1 Vues

Kickstart your cloud data career with Snowflake Data Engineer Training at Visualpath! Master data modeling, DBT, and pipeline automation with real-time projects. Enroll in Snowflake Data Engineering Training in Hyderabad to gain hands-on experience, expert guidance, and certification support to become a skilled data engineer. Call 91-7032290546 to book your free demo. WhatsApp: https://wa.me/c/917032290546 Visit Blog: https://visualpathtblogs.com/category/snowflake/ Visit: https://www.visualpath.in/snowflake-data-engineering-dbt-airflow-training.html

Snowflake Data Engineering with DBT| Online Training Visualpath

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

CDR Sample for Telecommunication Engineers PDF

Career Episode 1 a) Introduction CE 1.1 In the first career episode, I would like to describe my project “Ericsson Radio Base Station 3000 installation and commissioning”. I served as a Junior Engineer at Telecommunication Infrastructural Consultancy Services Pvt. Ltd. The project was started from 1st March 2009 to 17th March 2010. The project was based on Lucknow city U.P India. b) Background CE 1.2 The main aim of the project was to provide Ericsson solution to launch 3G services in UP (East) circle. Government-owned the Telecommunication ISP which gave a project to Ericsson for 3G rolled out in UP (East) circle.I attended 2 days of training in Ericsson office Gurgaon to know the functionality of Ericsson RBS 3000 which was launched in the market. In this project, the network was upgraded to 3G without impacting the existing 2G network. The ISP Provider wanted to become number one player to launch the services in short span of time to get the advantage of early launch as compared to other service providers. CE 1.3 Following were the responsibilities which I fulfilled in the project. • Conducted a survey of different sites and solve the encountered issues during survey • Identified the problems on the site and submitted a report to the General Manager • Coordinated with the project team during the installation of 3G network • Monitored the progress of the site and informed to the Project Manager • Attended the meetings arranged by the site coordinators • Checked the material before implementing on the site • Performed driven test to check the working of RBS • Ensured that the safe working procedure was followed during the design and installation CE 1.4 Given below is the project hierarchy. c) Personal Engineering Activity CE 1.5 Before starting the activities of the project, I needed to ensure the feasibility of required material on site.I started a sitesurvey and noted down material requirements. The requirement of the material on particular site depended on the feasibility of the site, space, and transmission etc.In this project, I used Ericsson 3G RBS3000. After survey the sites, I consolidated the data of the sites from the available Engineers in my team and send to the logistics team. I sent the information of the site data and the requirement of the material to the logistics team. I coordinated with logistics and warehouse team about material required on the site. I assigned a warehouse team who dispatched the materials to the sites. I coordinated with the teams to receive the site material. I checked the material as per requirements of the project. I returned the wrong material and asked them to re-ship the correct material. I made a dashboard in which I described all the details of the requirement. When material reached on site, I made sure about the availability of the required material. CE 1.6 I conducted a site test for 5 days. Then, I handed over the site to operations and maintenance team. The assigned operations and maintenance team gave feedback on installations issues which included jumper cable swap and wrong labeling. I corrected the punch points related to the site. I used to follow standards procedures to commission the site. I made sure about the transmission, media, and power availability in the site. CE 1.7 I received the call from my Project Manager that we had to launch 3G in Lucknow city in a month time. At that time, there were many sites pending for installation and commissioning. I made a track of every activity on the site. I arranged the meeting with General Manager of customer and my project manager to discuss timelines and issues of my project. I explained them about all challenges like access issues and key issues to enter the site. First of all, I visited all remaining 35 sites in three days to note down the material requirement. I clearly explained the material required in a mail to the logistics team in a warehouse and gave them timelines for material availability so that I received correct material on the site. CE 1.8 I faced many issuesduring the project like material availability, transmission, and media etc. I made a dashboard to resolve the issues and started working for my target to live all sites within a month time frame. I collected keys and resolved access related issues through issuing identity card and permission letter for vendor teams. I reached out to vendor teams to discuss it. After ensuring person availability, I was pretty sure about the installations on time. I decided a vendor team based on my previous experience with them and other employees feedback about the quality of their work. I instructed them about the installation guidelines and procedures. I instructed them about the safety and quality as well. I cross-checked their work by visiting random checks on sites. CE 1.9 I faced a problem during the installation of integration part. When I visited the site, I found that E1s were not routed to the BTS. I searched the location and find out from where to route. I routed E1s from existing BSNL site to my Ericsson BTS. I followed standard procedures to integrate my site. I defined the configuration which I had taken from planning and optimization team. I defined alarms on the site. After defining the integration of parameters, I punched all three E1s on the site. I tested the E1s and found that I was not able to find voltage and current in one E1. I tried to search the root cause of the problem but I was unable to do. I discussed with my senior colleagues but nobody confronted such type of issues before. I cross checked my media connections again. I found it all good. So I decided to go to the site from E1s was coming. When I reached on donor site, I found that all connections properly work. I tried to complete my E1 connectivity issue. I tried to integrate that site at any cost. I called up vendor’s team to check the issue on donor site. I inspected and found that there were issues in a link from hub site. So I checked on mini-link and found that one E1 was down. I investigated to know the reason why E1 was down.After checking, I found that the issue was in between hub site and my site. I further investigated the microwave link. I observed that there was a tall building constructed between hub site and my site. I instructed the team to uninstall microwave antenna and install again on some more height Line of sight to my site. After new installations, I got clear transmission of E1. I was able to resolve the issue after 2 days of hard work. CE 1.10 Firstly, I found the requirement of the customer. I took the responsibilities of Radio Access Network Infrastructure, BTS, transmission, and installation or commissioning of Ericsson RBS 3000. I gathered the required material to upgrade the network from 2nd generation to 3rd generation. For 3rd generation network, I installed different BTS and antennas on tower sites. To get the information of feasible and correct material, I conducted a field survey. In order to check the availability of existing 2G sites, I checked the Feasibility space. Then, I prepared a material list on site by site and submitted to logistics team so that they arranged the required material in a specified time frame. I started an installation work after completing the list of material. CE 1.11 During the installation, I followed safety standards. I made sure that the team used all safety equipment like rope and helmets etc. I called up the vendor teams to come with all safety and required tools to reach on the sites. I instructed the team well about the installation work. I made sure that my workers followed safety hazards during installation. After completing the installation work, I checked the quality inspection to make sure installation was as per the standards or not included labeling check and alarms verification. CE 1.12 I checked that transmission was available on 3G or not. I provided E1 to make the transmission feasible. The E1’s were routed from RNC to HUB to sub HUB to Node B. I completed the E1s routing through mini-link using the software. I performed configuration on Node B and it required n numbers of steps. After commissioning, I conducted a driving test to check the working of RBS in 3G. Before handover the site to operation and maintenance team, I corrected the encountered issues during a driven test. I checked different parameters to ensure that the site was properly worked or not. In the whole project, I followed IEEE and ITU standards. I carried out different calculations as per the project need. I measured the downlink and uplink frequency. I applied the formula for path loss calculation. CE 1.13 In this project, I prepared a report and presented it to the Manager and update him on the progress of the project. I described the activity of the work completed by my colleagues and explained the working hour, issues, and meeting with theproject manager, general manager, vendor team, and logistics team. I tried to use fine words in the report.I attended various official meetings and actively participated in them. d) Summary CE 1.14 I successfully launched the 3G network in the market. I completed the project within timelines. In spite of multiple issues like logistics and transmission etc, I was able to achieve the goal of the project. I submitted a tender to the organization. After the approval of the tender, I was awarded the project. I worked hard on this project tomake sure that no complaintwas received related to my work from the organization. I surveyed the site and after solving the issues on the site, I handed over to the vendor team. Career Episode 2  Introduction: CE 2.1 In this career episode, I will present a detailed account of my responsibilities and learning process during the project ‘BTS Alarm Monitoring and Troubleshooting’. On the basis of my capabilities, I was hired by Vihaan Networks Ltd. as Telecommunications Engineer. This project was developed for BSNL, India in the premises of Gurgaon, Haryana India. I participated in the development of this project from 29th March 2010 to 31st Aug 2011.  Background CE 2.2 Vihaan Networks Ltd. is a well reputed telecommunications enabler in India which is also an integral organization in the Shyam Group. Government owned Telecommunication ISP gave this project to VNL for BTS alarm monitoring because of VNL’s popularity and integrity in India. VNL developed BTS which worked without A.C. and worked on D.C. (battery). This application is particularly useful in areas where power is available in limited quantities. CE 2.3 BTS worked on solar cells which were charged in sun rays during day time. The project was aimed at establishing seamless connectivity for customer with low capital expenditure as it does not require power supply. The main objective of this project was to install BTS alarm monitoring system in fifty sites in the Rajasthan circle. When customer gave project to VNL, project team started survey to the sites. Next step in the project was to install the systems on these sites. CE 2.4 Being a responsible member of my team, I fulfilled following duties during this project: • Carried out a detailed literature survey to study methods of installing BTS alarm monitors • Trained my subordinates and listened to their problems from time to time • Prepared a flow chart to accomplish all the tasks of the project and assigned the timings of each task • Divided the work load among my team members • Assisted and supervised my teammates to make sure the work was executed flawlessly • Updated the project supervisor in weekly meetings and asked for his suggestions regarding the future tasks • Fulfilled all the requirements of the customer • Explained the future scope and advantages of the project • Abided by IEEE standards and referred to them in particular phases of the project CE 2.5 I developed a project team hierarchy to indicate my position in the team.  Personal Engineering Activity CE 2.6 I developed theoretical background of my project by studying about the methods of remote monitoring and controlling. I supported my RAN team remotely and alarm monitoring and controlling of 50 cell sites. I monitored alarms of all types in BTS and also carried out first level of troubleshooting. In first level of troubleshooting, I remotely cleared all the alarms. If this remote operation was made difficult because of backhaul, power, or hardware; I visited the site and resolved the issue. After diagnoses, I made ticket mentioning the event and sent it to the concerned stakeholders. I maintained network connectivity with the customer at all times. I divided the alarms into four major categories which are: critical major, minor and informational. Critical alarms were visible in red color like site down alarm or sector down alarm. Major alarms were shown in orange colors like radio down, battery low etc. I took actions against those alarms so that they cannot be service impacted. Minor alarms were presented in yellow colors. These alarms were non service impacted like amplifier failure etc. CE 2.7 According to the BTS design that I proposed in this project, I mapped 8 TRXs on some sectors while just 2 TRXs were present as per the physical inputs. I used the connection topology which is direct and equalized the distribution of power on each TRX by connecting a multiplexer. In my design, every TRX had a 3 dBm loss which was the fixed value at all times. This was due to the stages of multiplexers that had the same losses. A single multiplexer had a 3 dBm loss so as there were two multiplexers, each TRX had a 6 dBm loss. I connected 2 TRX input sector combiner with 8 TRXs. I also implemented a design to install an additional door sensor as the theft rates are usually high in online networks. The fence gates of the site could easy be broken as the door alarm alerted the centre of security operations, theft had already taken place. Using this technique, I carried out the installation of the door sensor and linked it to the door alarm in a series combination. I also gave instructions to my team to make sure that the security of the sites was not violated. CE 2.8 I designed a systematic approach to identify and troubleshoot the BTS alarm. I performed multiple tests on the concerned system and analyzed its performance. After the fault identification, I recorded the name of the fault and the product in question. I mentioned the unit that I used to identify the fault if any. I recorded the fault source and noted the difference between the source of alarm and the source that detects the fault. I analyze event type which was either transient or distur. I checked if the alarm fault were in a start or cancel state. I found ways to clear the alarm and defined the unit status that if it was out of order, working, or degraded. I recorded the effect of the fault on the unit and its operations. I checked the records of the reported alarms in the past to perform their trouble shooting techniques if the fault matched. At the end, I described the instructions that were required to clear the alarm. CE 2.9 I monitored all alarms in all sites of customers. My proposed design of BTS was able to be charged with solar energy and could be used when power was not available. It provided up to 24 hours backup when fully charged. This feature of our design was used to reduce capital expenditure of customers because in normal BTS, operators have to spend a large sum of money on resources such as diesel, generators etc. I tried to minimize the downtime by providing them on time alert and actions. Whenever I received an alarm, I tried to resolve it as soon as possible. I used to send service alert message whenever any outages were present. It included all stakeholders. I regularly updated the client on email as well as via message. When any critical alarm was found, I tried to resolve it remotely. After diagnosis of the problem, I informed field technician about the problem via phone call or message. I worked in 24 x 7 shifts to make sure that NOC desktop was not left unattended. When a new site was configured by project team, I performed alarm testing on that site to check that alarms were reported or not. I used my analytical skills to analyze the alarms. I diagnosed it further and resolved as soon as possible. CE 2.10 During the tenure, a great voltage standing wave ration detected on the sector combiner. At this time, I was implementing an upgrade action and became concerned about it. At the single feeder, the VSWR reading was 1.1 while I recorded a reading of 2.3 which was unacceptable for this project. I detected the exact issue by connecting the feeder to the site master at the site. The link was made using the lower terminal of the cable and I performed checks on it. I tested it while connecting the other feeder to the antenna. Another major concern was that there was no site master available as the system was going though an upgrade. I coordinated with the operations and maintenance team and performed troubleshooting to identify the root of the problem. I asked my team to interchange the feeder sector with another sector and performed cross sector of the BTS site. However, the VSWR remained the same on the new sector as well. I assigned a rigger technician for this job and came to know that the problem was either with the feeder cable or the antenna. I ordered the site master and after its arrival, I asked my team to make connections of the feeder with the combiner. The loss turned out to be 60 m far which was approximately the length of the feeder. I instructed the rigger to inspect the antenna and found that the jumper that connected the antenna with the feeder was broken. I ordered my team to replace and restore the connection after which the VSWR reading was accurate. CE 2.11 I faced many challenges during this project. An out of routine event occurred when 8 sites went down at the same time. From my list of connected sites, I found that these eight sites were part of a hub site that was also not functioning at that time. After that, I easily concluded that the issue was with hub site only. I checked backhaul test on the hub site and found that media was down at the site. I called backhaul engineer and sent him to the hub site. I assisted backhaul engineer in testing backhaul link from Network operation center and instructed him to change backhaul cable. CE 2.12 Throughout the course of this project, I followed several design and security standards. I primarily used Alliance for Telecommunications Industry Solutions (ATIS) to obtain guiding information in the design phase. Another source of standards to follow was IEEE Communication Society Standards for Dynamic Spectrum Access Networks. IEEE standard was used during the stage of alarm monitoring in the project. I was able to design a reliable network by following ATIS standards of operational and technical integrity. As a telecom engineer, it was my duty to responsibly use available resources and develop a system that is energy efficient. I performed my duties with extreme vigilance and maintained professional integrity throughout this project’s time. CE 2.13 I implemented cost friendly test procedures throughout this project to make sure that all the work was performed with maximum output utilizing minimum resources. I kept a check on all the purchases made during this time and performed a cost estimation analysis to determine the total cost of the project. Finally, I prepared a report and added the cost calculation in it to justify my resourcefulness during this project. All the documenting tasks were accomplished using MS-Word Document. I made progress reports throughout the duration of this project which were analyzed by our manager. I used MS Project to prepare a timeline and plan for the project. This helped in timely achievement of project’s objectives. CE 2.14 I arranged frequent meetings with my manager to discuss the progress of this project. As the lead telecom engineer, I made it mandatory for all group members to attend these meetings so that everyone gained knowledge from remarks of the manager. I took notes of manager’s remarks about my work and accomplished assigned tasks in time. I inspired a sense of trust and friendship among the team members so that they were motivated to perform better in this project. I lead by example and fulfilled my responsibilities before pointing out their mistakes. After the completion of this project, I arranged an informal party for team members to appreciate everyone’s contribution in the success of this project. CE 2.15 I promoted a learning atmosphere in the workplace and gave short study assignments to the workers for weekend. I implemented the same approach for myself and during off-hours, I sat down to study. I applied my theoretical knowledge in the practical field and taught the same to my colleagues. As a result of this project, all of us improved our technical skills and took knowledge home with us. All the members of the project worked in consonance and assisted each other when needed. Our aim was to prosper our company so we burnt midnight oil to achieve our collective goal.  Summary CE 2.16 This project gave me the confidence to design and develop a product from scratch. I was also acclaimed by top management for the successful implementation of our designed product. I managed to achieve all the objectives timely and successfully. I enhanced my communication skills and got to know the worth of team work and coordination in a project. I also got to learn about various project management techniques including project scope statement and Work Breakdown Structure. The product installed in this project on fifty different sites was an eco-friendly product that is most suitable in areas with no or very little power. It has numerous other benefits and applications that can be used for the betterment of technical society. Career Episode 3  Introduction CE 3.1 This career episode presents details of my performance and activities in the project that was carried out during my employment at Reliance JioInfocomm Limited. The project was titled ‘Town Optimization and Capacity Planning’. I was working in the capacity of Senior Manager. The project was completed during the time period of 18thApril 2016 to 31stAug 2017in Mumbai, India.  Background CE 3.2 JioInfocomm Limited started the project to optimize the towns of India. I was responsible for project execution in South India Zone where South Indian Towns were optimized according to the set benchmark. The motivation behind this project was Jio’s plan to commercially launch the LTE services PAN India. Before launching it wanted to ensure that all towns were optimized and ready for launching the services.The commercial launch of this network was done on 5thSeptember 2016 and it was free for every customer to make unlimited calls and utilize unlimited data as well. CE 3.3 The aim of this project was to make sure that all major roads of towns were covered in drive test route of the town. To achieve this, weensured that our network was available with good customer experience. The project also aimed at passing all major KPIs like RSRP, SINR, CQI, RLF, IP Throughput for that town. At first stage, DT KPIs were tested and passed. Then other towns KPIs were passed like CQI, RLF, IP Throughput etc. on world’s largest LTE network. After launching, the project was mainly concerned minimization of decongestion in the network. New sites were planned and new outdoor small cells were developed to render the network digestion free. The objective of the project was to provide seamless network and connectivity for all customers. First, it was based on drive data and later on Key Performance Indicators. CE 3.4 I completed following tasks during the course of this project: • Performed the activities of an as team leader • Carried out an extensive literature survey of norms and standards governing installation of LTE networks • Designed and planned new sites for decongestion of networks • Designed a drive test route for the project • Monitored the activities of the project in the capacity of a Senior Manager • Analyzed the KPIs in case of failure or malfunctioning • Managed the workload for my subordinates • Prepared a final project report along with a presentation CE 3.5 Below mentioned project hierarchy is an indication of my position in the organization.  Personal Engineering Activity CE 3.6 I started off this project by going through the concepts of “Wireless Communications” course that I studied during my engineering degree. Since this project was being implemented in multiple towns, I devised ways to make sure that all teams followed thesame set of principles in their respective towns. I started off the project by measuring the network parameters. I designed and implemented the drive test route instructed the engineers that drive test route must be followed to major roads in thecity. This enabled my team to keep a check on the network KPIs in the town. I conducted the drive test by riding a bike with X-CAP software installed on the mobile phone to capture drive logs. I followed drive test route through an app named as “map inr” which provided the entire route in a single app. With the use of this app, drive test route was followed maximum by me and other drive testers. CE 3.7 I downloaded the drive test results from “Actix Tool”. I instructed the drivers to carry out the drive tests in two modes: 1st mode was with avoice call, 2nd was with data call. The reason behind following these two methods was to capture both voice and data KPIs. I decided whether a KPI passed or failed according to the set threshold. In case of failure, I analyzed the rejected KPI. There were three frequency bands available in Jio network- 2300 MHz, 1800 MHz, and 850 MHz. I implemented the method of tilt harmonization in all three bands. According to that, first I lowered the degree of tilt in 2300 MHz band so that it covered maximum footprint as compared to 1800 MHz band. The logic behind it was throughput was maximum in 2300 MHz band because of its 20 MHz bandwidth.So, I always tried to give maximum coverage to our 2300 MHz band for better user experience. I exploited the principle of reciprocity between frequency and distance to give maximum coverage to 2300 MHz band. CE 3.8 I determined the bandwidth requirement of the area that can meet the demand without increasing the cost using the statistical data of the area and its network quality. For this, I first measured the bandwidth of the available network. Next, I measured the average rate of utilization and quality of the mobile call. I executed my responsibilities in case of failures in different parts of the network. I remedied the following failures by using my expertise of troubleshooting: • If thetown was failed in RSRP that meant coverage was bad. So, I had to study about RSRP patches and optimize them to the best possible state • If thetown was failed in SINR that meant quality was impacted. So, I had to improve SINR to enhance throughput and customer experience as well • If town KPIs were failed in attached success rate, it meant that there weresome issues in accessibility KPI • If town KPI were below threshold in drop success rate, that meant there weresome problems in retaining ability of KPI • If town was failed in CQI, that meant quality was impacted and customer experience was being compromised • If town KPI was failed in throughput, that meant town was failed in Integrity of KPI • If town was failed in Radio Link failure, that meant customer experience was bad CE 3.9 I performed selection process of sites for which is an important process in planning an efficient cellular network. The selected sites formed a set of the network that fulfilled the requirements of high coverage of the area and high capacity of traffic. I developed a configuration of base stations by modeling a complex problem involving various antenna types such as omnidirectional antennas, multi-directional antennas, tilt, power control, and azimuth. By calculating different aspects of the system, I developed a model which estimated important values of the requirement of service threshold, the demandfor traffic, and estimation of propagation loss. With the help of my team members, I also developed a model for the problem of frequency assignment. This model enabled me to generate a plan for the frequency that minimized electromagnetic interference because of frequency reuse in various components of the cellular network. CE 3.10 I faced several challenges in this project. One of the most difficult challenges I faced was deterioration of signal quality because of frequency assignment. After careful analysis, I found that the level of deterioration was dependent upon the value of SIR. I resolved this problem by conducting a trial and error method where the value of was adjusted over a range of available values. Another challenge I faced was the failure of RLF KPI in one town.I analyzed further and found that there was no major issue on that site. All hardware and alarms were in good condition.I found all other KPI were functioning properly in that town. On further drill down, I came to know that major defaulter was one site that was causing RLF in lakhs. That was contributing to making RLF KPI fail for that town. I had checked tilts and all physical parameters were optimal on that site. On further investigation, I came to know that RLF failure occurred in one hour in evening time from 7 PM to 8 PM. After discussion with my team members, I concluded that problem was arising from power fluctuations in the neighbor sites. I resolved this issue of power fluctuations by running various tests on the power supply and stabilizing its output. CE 3.11 I followed a number of standards during this project. I primarily used IEEE CommunicationSociety Standards for Dynamic Spectrum Access Networks and Alliance for Telecommunications Industry Solutions (ATIS) to obtain guiding information in the design phase. At the troubleshooting stage, I took help from IEEE standards while planning new sites for decongestion of networks. CE 3.12 I used a range of computer programs throughout the tenure of this project. I used X-Cap software to conduct drive tests at the initial stages of the project. ‘Map in’ and ‘Actix Tool’ were used while finalizing the tests for drive routes. I also gained expertise in Microsoft Office Suite during this project. I prepared different documents in Microsoft Word, conducted cost analysis in Microsoft Excel, and prepared presentations in Microsoft PowerPoint. CE 3.13 I frequently arranged meetings to instruct my subordinates about future tasks they were required to perform. I pointed out their mistakes and guided them in the right direction. There were meetings at the end of every month with other engineers to discuss the current status and issues. I was also responsible for reporting to my manager who kept track of project’s progress. I practiced my leadership skills in the best way possible and enhanced my communication skills by interacting with colleagues at different levels. I prepared progress reports which indicated different aspects of the project including progress, drawbacks, limitations, problems, achievements, technologies, and methods. I made sure my design was economical and no resources of the organization were being wasted. Along with maintaining a professional working environment, I encouraged my team members to take some time off during shifts. I planned a schedule of shifts for all the members to ensure smooth flow of work.  Summary CE 3.14 I felt honored in completing this project of extreme practical importance. I practiced the engineering principles learned in my studies. It was a challenging project and offered opportunities to improve my skills and professional growth. The project of ‘Town Optimization and Capacity Planning’ was successfully completed while working as a Senior Manager at JioInfocomm Limited. PROFESSIONAL ENGINEER Summary Statement Competency Element A brief summary of how you have applied the element Paragraph in the career episode(s) where the element is addressed PE1 KNOWLEDGE AND SKILL BASE PE1.1 Comprehensive, theory-based understanding of the underpinning natural and physical sciences and the engineering fundamentals applicable to the engineering discipline I explored the broader aspects of telecommunication engineering and applied technical codes to accomplish the crucial stages of this project CE 1.6, CE 1.7, CE 1.8, CE 1.9, CE 1.10, CE 2.6, CE 2.7, CE 2.8, CE 2.9, CE 2.10, CE 2.11, CE 3.6, CE 3.7, CE 3.8, CE 3.9, CE 3.10 PE1.2 Conceptual understanding of the mathematics, numerical analysis, statistics and computer and information sciences which underpin the engineering discipline I developed networking models and estimated important parameters and calculated different aspects of the communication system CE 1.12, CE 2.13, CE 3.9 PE1.3 In-depth understanding of specialist bodies of knowledge within the engineering discipline I implemented X-Cap software to conduct drive tests n the beginning stages of the projects and Map in and Actix Tool were used n the final stagesto finalize the tests for drive routes CE 1.12, CE 2.13, CE 3.6, CE 3.12 PE1.4 Discernment of knowledge development and research directions within the engineering discipline I kept a track of the project’s progress and continuously updated my knowledge for a successful outcome CE 1.3, CE 1.5, CE 2.4, CE 2.6, CE 2.15, CE 3.4, CE 3.6, CE 3.13 PE1.5 Knowledge of contextual factors impacting the engineering discipline I used proposed standards and implemented IEEE Communication Society Standards for Dynamic Spectrum Access Networks CE 1.6, CE 1.9, CE 1.12, CE 2.4, CE 2.12, CE 3.6, CE 3.11 PE1.6 Understanding of the scope, principles, norms, accountabilities and bounds of contemporary engineering practice in the specific discipline To accomplish multiple designing tasks, I abided by engineering rules and consulted recommended study material Alliance for Telecommunications Industry Solutions (ATIS) standards helped me to obtain a direction to approach the design I prevented potential risks and hazards that were associated with communication systems. I made the use of safety equipment mandatory CE 1.10, CE 2.7, CE 2.8, CE 2.9, CE 3.4, CE 3.6, CE 3.7, CE 3.8, CE 3.9 CE 1.6, CE 1.9, CE 1.12, CE 2.4, CE 2.12, CE 3.6, CE 3.11 CE 1.3, CE 1.8, CE 1.11, CE 2.12, CE 3.13 PE2 ENGINEERING APPLICATION ABILITY PE2.1 Application of established engineering methods to complex engineering problem solving I faced paramount challenges in these projects that I conquered using my strong technical capabilities and assistance of my team CE 1.6, CE 1.7, CE 1.8, CE 1.9, CE 2.6, CE 2.8, CE 2.9, CE 2.10, CE 2.11, CE 3.8, CE 3.10 PE2.2 Fluent application of engineering techniques, tools and resources I implemented Microsoft Office Suite and other Microsoft software applications to organize the project data CE 1.12, CE 2.13, CE 3.6, CE 3.12 PE2.3 Application of systematic engineering synthesis and design processes My designs were solely based on telecommunication engineering principles and technical laws CE 1.10, CE 2.7, CE 2.8, CE 2.9, CE 3.4, CE 3.6, CE 3.7, CE 3.8, CE 3.9 PE2.4 Application of systematic approaches to the conduct and management of engineering projects Being a responsible team leader, I kept my team united and made sure that all the activities were synchronized I took the project costs into account and panned the tasks accordingly CE 1.3, CE 1.4, CE 1.5, CE 1.6, CE 1.9, CE 1.11, CE 1.13, CE 2.4, CE 2.5, CE 2.6, CE 2.14, CE 3.4, CE 3.5, CE 3.6, CE 3.13 CE 1.3, CE 1.11, CE 2.13, CE 3.13 PE3 PROFESSIONAL AND PERSONAL ATTRIBUTES PE3.1 Ethical conduct and professional accountability I implemented the standards of IEEE and to ensure safety, I followed OHSA standards I performed risk analysis and checked whether or not the probability of a risk to occur was more or less CE 1.6, CE 1.9, CE 1.12, CE 2.4, CE 2.12, CE 3.6, CE 3.11 CE 1.3, CE 1.8, CE 1.11, CE 2.12, CE 3.13 PE3.2 Effective oral and written communication in professional and lay domains I displayed my interactive skills by participating in the project meetings and giving weekly project presentations CE 1.3, CE 1.7, CE 1.9, CE 1.13, CE 2.4, CE 2.13, CE 2.14, CE 3.4, CE 3.12, CE 3.13, CE 3.13 PE3.3 Creative innovative and proactive demeanour I studied latest technologies and got indulged in technical conversations with my colleagues to update my information CE 1.3, CE 1.5, CE 2.4, CE 2.6, CE 2.15, CE 3.4, CE 3.6, CE 3.13 PE3.4 Professional use and management of information I documented progress reports which indicated different aspects of the project including progress, constraints, drawbacks, problems, milestones, methods, and techniques CE 1.13, CE 2.13, CE 3.4, CE 3.12, CE 3.13 PE3.5 Orderly management of self, and professional conduct I organized the activities of the projects right from the beginning and made sure that the task schedule was being followed I went through books and research papers regarding modern communication systems to get creative ideas CE 1.5, CE 2.4, CE 3.4, CE 3.13 CE 1.3, CE 1.5, CE 2.4, CE 2.6, CE 2.15, CE 3.4, CE 3.6, CE 3.13 PE3.6 Effective team membership and team leadership I maintained professional working environment and ensured that my team members worked actively. I adopted an encouraging approach to deal with them CE 1.3, CE 1.4, CE 1.5, CE 1.6, CE 1.9, CE 1.11, CE 1.13, CE 2.4, CE 2.5, CE 2.6, CE 2.14, CE 3.4, CE 3.5, CE 3.6, CE 3.13

250 views • 20 slides

QNT 561 Motivated Minds /newtonhelp.com

QNT 561 Entire Course (With Final Guide) For more course tutorials visit www.newtonhelp.com QNT 561 Final Exam Guide (New, 2017) QNT 561 Week 1 Assignment Statistics Concepts and Descriptive Measures Instructions (Financial Data) QNT 561 Week 1 Assignment Statistics Concepts and Descriptive Measures Instructions (Consumer Food) QNT 561 Week 2 Case Study MBA Schools in Asia Pacific (2 Papers) QNT 561 Week 3 Case Study SuperFun Toys (2 Papers) QNT 561 Week 3 Assignment Expansion Strategy and Establishing a Re-Order Point QNT 561 Week 4 Case the Payment Time QNT 561 Week 5 Spicy Wings Case Study QNT 561 Week 5 Team One-Sample Hypothesis Testing (Election Results, SpeedX) QNT 561 Week 6 Signature Assignment (Hospital) QNT 561 Week 6 Signature Assignment (Consumer Food) =============================================== QNT 561 Entire Course (Without Final Guide) For more course tutorials visit www.newtonhelp.com QNT 561 Week 1 Assignment Statistics Concepts and Descriptive Measures Instructions (Financial Data) QNT 561 Week 1 Assignment Statistics Concepts and Descriptive Measures Instructions (Consumer Food) QNT 561 Week 2 Case Study MBA Schools in Asia Pacific (2 Papers) QNT 561 Week 3 Case Study SuperFun Toys (2 Papers) QNT 561 Week 3 Assignment Expansion Strategy and Establishing a Re-Order Point QNT 561 Week 4 Case the Payment Time QNT 561 Week 5 Spicy Wings Case Study QNT 561 Week 5 Team One-Sample Hypothesis Testing (Election Results, SpeedX) QNT 561 Week 6 Signature Assignment (Hospital) QNT 561 Week 6 Signature Assignment (Consumer Food) =============================================== QNT 561 Final Exam Guide (Score 29/30 New, 2019) For more course tutorials visit www.newtonhelp.com 1. James Desreumaux, VP of Human Resources of American First Banks (AFB), is reviewing the employee training programs of AFB banks. His staff randomly selected personnel files for 100 tellers in the Southeast Region and determined that their mean training time was 25 hours. Assume that the population standard deviation is 5 hours. The 95% confidence interval for the population mean of training times is 2. If x is a binomial random variable with n=10 and p=0.8, the mean value of x is______ 3. According to the central limit theorem, for samples of size 64 drawn from a population with µ =800 and σ = 56, the standard deviation of the sampling distribution of sample means would equal ______ 4. Life tests performed on a sample of 13 batteries of a new model indicated: (1) an average life of75 months, and (2) a standard deviation of 5 months. Other battery models, produced by similar processes, have normally distributed life spans. The 98% confidence interval for the population mean life of the new model is _________ 5. A large national company is considering negotiating cellular phone rates for its employees Human Resource department would like to estimate the proportion of its employee population who own an Apple iPhone. A random sample of size 250 is taken and 40% of the sample own and iPhone.. The 95% confidence interval to estimate the population proportion is _______ 6. The number of bags arriving on the baggage claim conveyor belt in a 3 minute time period would best be modeled with the ________ 7. The weight of a USB flash drive is 30 grams and is normally distributed. Periodically, quanlity control inspectors at Dallas Flash Drives randomly select a sample of 17 USB flash drive. If the mean weight of the USB flash drives is too heavy or too light the machinery is shut down for adjustment; otherwise, the production process continues. The last sample showed a meanand standard deviation of 31.9 and 1.8 grams, respectively. Using a = 0.10, theappropriate decision is_______ 8. Elwin Osbourne, CIO at GFS, Inc., is studying employee use of GFS e-mail for non-business communications. He plans to use a 95% confidence interval estimate of the proportion of e-mail messages that are non-business; he will accept a 0.05 error. Previous studies indicate that approximately 30% of employee e-mail is not business related. Elwin should sample _______ e-mail messages 9. The following frequency distribution was constructed for the wait times in the emergency room The frequency distribution reveals that the wait times in the emergency room are _______ 10. The number of cars arriving at a toll booth in five-minute intervals is Poisson distributed with a mean of 3 cars arriving in five-minute time intervals. The probability of 5 cars arriving over a five-minute interval is ________ 11. The number of finance majors within the School of Business is an example of _______ 12. According to the central limit theorem, for samples of size 64 drawn from a population with µ = 800 and σ = 56, the mean of the sampling distribution of sample means would equal _______ 13. Consider the following null and alternative hypotheses Ho: m ≤ 67 Ha: m > 67 These hypotheses ___________ 14. A market research team compiled the following discrete probability distribution on the numberof sodas the average adult drinks each day. In this distribution, x represents the number of sodas which an adult drinks x P(x) 0 0.30 1 0.10 2 0.50 3 0.10 The mean (average) value of x is ______________ 15. A researcher wants to determine the sample size necessary to adequately conduct a study to estimate the population mean to within 5 points. The range of population values is 80 and the researcher plans to use a 90% level of confidence. The sample size should be at least ______ 16. The mean life of a particular brand of light bulb is 1200 hours. If you know that at about 95% of this brand of bulbs will last between 1100 and 1300 hours, then what is the standard deviation of the light bulbs’ life? 17. Completion time (from start to finish) of a building remodeling project is normally distributed with a mean of 200 work-days and a standard deviation of 10 work-days. To be 99% sure that we will not be late in completing the project, we should request a completion time of ______ work-day. 18. A large industrial firm allows a discount on any invoice that is paid within 30 days. Of all invoices, 10% receive the discount. In a company audit, 10 invoices are sampled at random. The probability that fewer than 3 of the 10 sampled invoices receive the discount is approximately_______________. 19. Suppose a population has a mean of 400 and a standard deviation of 24. If a random sample of size 144 is drawn from the population, the probability of drawing a sample with a mean less than 402 is _______ 20. If x is a binomial random variable with n=10 and p=0.8, what is the probability that x is equal to 4 ? 21. The normal distribution is used to test about a population mean for large samples if the population standard deviation is known. "Large" is usually defined as _______ 22. Lucy Baker is analyzing demographic characteristics of two television programs, Americandol (population 1) and 60 Minutes (population 2). Previous studies indicate no difference in the ages of the two audiences (The mean age of each audience is the same.) Lucy plans to test this hypothesis using a random sample of 100 from each audience. Her null hypothesis is 23. Maureen McIlvoy, owner and CEO of a mail order business for wind surfing equipment and supplies, is reviewing the order filling operations at her warehouses. Her goal is 100% of orders shipped within 24 hours. In previous years, neither warehouse has achieved the goal, but the East Coast Warehouse has consistently out-performed the West Coast Warehouse. Her staff randomly selected 200 orders from the West Coast Warehouse (population 1) and 400 orders from the East Coast Warehouse (population 2), and reports that 190 of the West Coast Orders were shipped within 24 hours, and the East Coast Warehouse shipped 372 orders within 24 hours. Maureen's alternate hypothesis is _______ 24. Ophelia O'Brien, VP of Consumer Credit of American First Banks (AFB), monitors the default rate on personal loans at the AFB member banks. One of her standards is "no more than 5% of personal loans should be in default." On each Friday, the default rate is calculated for a sample of 500 personal loans. Last Friday's sample contained 30 defaulted loans. Ophelia's null hypothesis is _______. 25. Catherine Chao, Director of Marketing Research, is evaluating consumer acceptance of a new toothpaste package. Her staff reports that 17% of a random sample of 200 households prefers the new package to all other package designs. If Catherine concludes that 17% of all households prefer the new package, she is using _______. 26. The empirical rule says that approximately what percentage of the values would be within 2 standard deviations of the mean in a bell shaped set of data 27. Medical Wonders is a specialized interior design company focused on healing artwork. The CEO, Kathleen Kelledy claims that artwork has healing effects for patients staying in a hospital, as measured by reduced length of stay. Her current client is a children’s cancer hospital. Kathleen is interested in determining the effect of three different pieces of healing artwork on children. She chooses three paintings (a horse photo, a bright abstract, and a muted beach scene) and randomly assigns six hospital rooms to each painting. Kathleen's null hypothesis is _____________ 28. The expected (mean) life of a particular type of light bulb is 1,000 hours with a standard deviation of 50 hours. The life of this bulb is normally distributed. What is the probability that a randomly selected bulb would last fewer than 940 hours 29. The mean life of a particular brand of light bulb is 1200 hours and the standard deviation is 75 hours. Tests show that the life of the bulb is approximately normally distributed. It can be concluded that approximately 68% of the bulbs will last between _______. 30. A market researcher is interested in determining the average income for families in San Mateo County, California. To accomplish this, she takes a random sample of 300 families from the county and uses the data gathered from them to estimate the average income for families of the entire county. This process is an example of _______. =============================================== QNT 561 Final Exam Guide (Score 29/30 New, 2019) For more course tutorials visit www.newtonhelp.com 1. James Desreumaux, VP of Human Resources of American First Banks (AFB), is reviewing the employee training programs of AFB banks. His staff randomly selected personnel files for 100 tellers in the Southeast Region and determined that their mean training time was 25 hours. Assume that the population standard deviation is 5 hours. The 95% confidence interval for the population mean of training times is 2. If x is a binomial random variable with n=10 and p=0.8, the mean value of x is______ 3. According to the central limit theorem, for samples of size 64 drawn from a population with µ =800 and σ = 56, the standard deviation of the sampling distribution of sample means would equal ______ 4. Life tests performed on a sample of 13 batteries of a new model indicated: (1) an average life of75 months, and (2) a standard deviation of 5 months. Other battery models, produced by similar processes, have normally distributed life spans. The 98% confidence interval for the population mean life of the new model is _________ 5. A large national company is considering negotiating cellular phone rates for its employees Human Resource department would like to estimate the proportion of its employee population who own an Apple iPhone. A random sample of size 250 is taken and 40% of the sample own and iPhone.. The 95% confidence interval to estimate the population proportion is _______ 6. The number of bags arriving on the baggage claim conveyor belt in a 3 minute time period would best be modeled with the ________ 7. The weight of a USB flash drive is 30 grams and is normally distributed. Periodically, quanlity control inspectors at Dallas Flash Drives randomly select a sample of 17 USB flash drive. If the mean weight of the USB flash drives is too heavy or too light the machinery is shut down for adjustment; otherwise, the production process continues. The last sample showed a meanand standard deviation of 31.9 and 1.8 grams, respectively. Using a = 0.10, theappropriate decision is_______ 8. Elwin Osbourne, CIO at GFS, Inc., is studying employee use of GFS e-mail for non-business communications. He plans to use a 95% confidence interval estimate of the proportion of e-mail messages that are non-business; he will accept a 0.05 error. Previous studies indicate that approximately 30% of employee e-mail is not business related. Elwin should sample _______ e-mail messages 9. The following frequency distribution was constructed for the wait times in the emergency room The frequency distribution reveals that the wait times in the emergency room are _______ 10. The number of cars arriving at a toll booth in five-minute intervals is Poisson distributed with a mean of 3 cars arriving in five-minute time intervals. The probability of 5 cars arriving over a five-minute interval is ________ 11. The number of finance majors within the School of Business is an example of _______ 12. According to the central limit theorem, for samples of size 64 drawn from a population with µ = 800 and σ = 56, the mean of the sampling distribution of sample means would equal _______ 13. Consider the following null and alternative hypotheses Ho: m ≤ 67 Ha: m > 67 These hypotheses ___________ 14. A market research team compiled the following discrete probability distribution on the numberof sodas the average adult drinks each day. In this distribution, x represents the number of sodas which an adult drinks x P(x) 0 0.30 1 0.10 2 0.50 3 0.10 The mean (average) value of x is ______________ 15. A researcher wants to determine the sample size necessary to adequately conduct a study to estimate the population mean to within 5 points. The range of population values is 80 and the researcher plans to use a 90% level of confidence. The sample size should be at least ______ 16. The mean life of a particular brand of light bulb is 1200 hours. If you know that at about 95% of this brand of bulbs will last between 1100 and 1300 hours, then what is the standard deviation of the light bulbs’ life? 17. Completion time (from start to finish) of a building remodeling project is normally distributed with a mean of 200 work-days and a standard deviation of 10 work-days. To be 99% sure that we will not be late in completing the project, we should request a completion time of ______ work-day. 18. A large industrial firm allows a discount on any invoice that is paid within 30 days. Of all invoices, 10% receive the discount. In a company audit, 10 invoices are sampled at random. The probability that fewer than 3 of the 10 sampled invoices receive the discount is approximately_______________. 19. Suppose a population has a mean of 400 and a standard deviation of 24. If a random sample of size 144 is drawn from the population, the probability of drawing a sample with a mean less than 402 is _______ 20. If x is a binomial random variable with n=10 and p=0.8, what is the probability that x is equal to 4 ? 21. The normal distribution is used to test about a population mean for large samples if the population standard deviation is known. "Large" is usually defined as _______ 22. Lucy Baker is analyzing demographic characteristics of two television programs, Americandol (population 1) and 60 Minutes (population 2). Previous studies indicate no difference in the ages of the two audiences (The mean age of each audience is the same.) Lucy plans to test this hypothesis using a random sample of 100 from each audience. Her null hypothesis is 23. Maureen McIlvoy, owner and CEO of a mail order business for wind surfing equipment and supplies, is reviewing the order filling operations at her warehouses. Her goal is 100% of orders shipped within 24 hours. In previous years, neither warehouse has achieved the goal, but the East Coast Warehouse has consistently out-performed the West Coast Warehouse. Her staff randomly selected 200 orders from the West Coast Warehouse (population 1) and 400 orders from the East Coast Warehouse (population 2), and reports that 190 of the West Coast Orders were shipped within 24 hours, and the East Coast Warehouse shipped 372 orders within 24 hours. Maureen's alternate hypothesis is _______ 24. Ophelia O'Brien, VP of Consumer Credit of American First Banks (AFB), monitors the default rate on personal loans at the AFB member banks. One of her standards is "no more than 5% of personal loans should be in default." On each Friday, the default rate is calculated for a sample of 500 personal loans. Last Friday's sample contained 30 defaulted loans. Ophelia's null hypothesis is _______. 25. Catherine Chao, Director of Marketing Research, is evaluating consumer acceptance of a new toothpaste package. Her staff reports that 17% of a random sample of 200 households prefers the new package to all other package designs. If Catherine concludes that 17% of all households prefer the new package, she is using _______. 26. The empirical rule says that approximately what percentage of the values would be within 2 standard deviations of the mean in a bell shaped set of data 27. Medical Wonders is a specialized interior design company focused on healing artwork. The CEO, Kathleen Kelledy claims that artwork has healing effects for patients staying in a hospital, as measured by reduced length of stay. Her current client is a children’s cancer hospital. Kathleen is interested in determining the effect of three different pieces of healing artwork on children. She chooses three paintings (a horse photo, a bright abstract, and a muted beach scene) and randomly assigns six hospital rooms to each painting. Kathleen's null hypothesis is _____________ 28. The expected (mean) life of a particular type of light bulb is 1,000 hours with a standard deviation of 50 hours. The life of this bulb is normally distributed. What is the probability that a randomly selected bulb would last fewer than 940 hours 29. The mean life of a particular brand of light bulb is 1200 hours and the standard deviation is 75 hours. Tests show that the life of the bulb is approximately normally distributed. It can be concluded that approximately 68% of the bulbs will last between _______. 30. A market researcher is interested in determining the average income for families in San Mateo County, California. To accomplish this, she takes a random sample of 300 families from the county and uses the data gathered from them to estimate the average income for families of the entire county. This process is an example of _______. . =============================================== QNT 561 Week 1 Assignment Statistics Concepts and Descriptive Measures Instructions (Consumer Food) For more course tutorials visit www.newtonhelp.com Purpose of Assignment The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics. Students will also get a chance to warm-up on evaluating some basic descriptive statistics using Excel® prior to the course start. Assignment Steps This assignment has an Excel dataset spreadsheet attached. Resource: Microsoft Excel, Statistics Concepts and Descriptive Measures Data Set Download the Statistics Concepts and Descriptive Measures Data Set. Choose: • Financial Answer each of the following in a total of 90 words: • For each column, identify whether the data is qualitative or quantitative. • Identify the level of measurement for the data in each column. • For each column containing quantitative data: • Evaluate the mean and median • Interpret the mean and median in plain non-technical terms • Use the Excel =AVERAGE function to find the mean • Use the Excel =MEDIAN function to find the median • For each column containing quantitative data: • Evaluate the standard deviation and range • Interpret the standard deviation and range in plain non-technical terms • Use the Excel =STDEV.S function to find the standard deviation • For range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel's =MIN function Annual Food Spending ($) Annual Household Income ($) Non mortgage household debt ($) 8909 56697 23180 5684 35945 7052 10706 52687 16149 14112 74041 21839 13855 63182 18866 15619 79064 21899 2694 25981 8774 9127 57424 15766 13514 72045 27685 6314 38046 8545 7622 52408 28057 4322 41405 6998 3805 29684 4806 6674 49246 13592 7347 41491 4088 2911 26703 15876 8026 48753 16714 8567 55555 16783 10345 71483 21407 8694 50980 19114 8821 46403 7817 8678 51927 14415 14331 84769 17295 9619 59062 16687 9286 57952 14161 8206 58355 19538 16408 81694 15187 12757 69522 14651 17740 96132 0 =============================================== QNT 561 Week 1 Assignment Statistics Concepts and Descriptive Measures Instructions (Financial Data) For more course tutorials visit www.newtonhelp.com Purpose of Assignment The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics. Students will also get a chance to warm-up on evaluating some basic descriptive statistics using Excel® prior to the course start. Assignment Steps This assignment has an Excel dataset spreadsheet attached. Resource: Microsoft Excel, Statistics Concepts and Descriptive Measures Data Set Download the Statistics Concepts and Descriptive Measures Data Set. Choose: • Financial Answer each of the following in a total of 90 words: • For each column, identify whether the data is qualitative or quantitative. • Identify the level of measurement for the data in each column. • For each column containing quantitative data: • Evaluate the mean and median • Interpret the mean and median in plain non-technical terms • Use the Excel =AVERAGE function to find the mean • Use the Excel =MEDIAN function to find the median • For each column containing quantitative data: • Evaluate the standard deviation and range • Interpret the standard deviation and range in plain non-technical terms • Use the Excel =STDEV.S function to find the standard deviation • For range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel's =MIN function Company Type Total Revenues AFLAC 6 7251 Albertson's 4 14690 Allstate 6 20106 Amerada Hess 7 8340 American General 6 3362 American Stores 4 19139 Amoco 7 36287 Arco Chemical 2 3995 Ashland 7 14319 Atlantic Richfield 7 19272 Bausch & Lomb 5 1916 Baxter International 5 6138 Bristol-Myers Squibb 5 16701 Burlington Coat 1 1777 Central Maine Power 3 954 Chevron 7 41950 CIGNA 6 14935 Cinergy 3 4353 Dayton Hudson 1 27757 Dillard's 1 6817 Dominion Resources 3 7678 Dow Chemical 2 20018 DPL 3 1356 E. I. DuPont DeNemours 2 46653 Eastman Chemical 2 4678 Edison International 3 9235 Engelhard 2 3631 Entergy 3 9562 Equitable 6 9666 =============================================== QNT 561 Week 1 DQ 1 For more course tutorials visit www.newtonhelp.com How may variance and standard deviation be applied to a real-world business-related problem? Provide a specific application in which these measures are useful. =============================================== QNT 561 Week 1 DQ 2 For more course tutorials visit www.newtonhelp.com When would you use Chebyshev’s theorem and the empirical rule in business? How are they calculated? Provide one real-life example that requires Chebyshev’s theorem and one that requires the empirical rule. =============================================== QNT 561 Week 1 Individual My Statslab Problem Set For more course tutorials visit www.newtonhelp.com 1. What is statistics? 2. Explain the difference between descriptive and inferential statistics. 3. Explain the difference between qualitative and quantitative data. 4. Explain how populations and variables differ. 5. Explain how populations and samples differ. 6. What is a representative sample? 7. Explain the difference between a population and a process. 8. Define statistical thinking. 9. Suppose you’re given a data set that classifies each sample unit into one of four categories: A, B, C or D. You plan to create a computer database consisting of these data, and you decide to code the data as A = 1, B = 2, C = 3 and D = 4. Are the data consisting of the classifications A, B, C and D qualitative or quantitative? After the data are in out as 1, 2, 3, or 4, are they qualitative or quantitative? 10. Identify each of the following variables as qualitative or quantitative. 11. Each month interviewers visit about 69,000 of the 93 million households in the region and question the occupants over 18 years of age about their educational status. Their responses enable the interviewers to estimate the percentage of people in the labor force who are college educated. Compare parts a through c. 12. Complete the table to the right? 13. In one university, language professors incorporated a 10-week extensive program to improve students’ Japanese reading comprehension. The professors collected 283 books originally written for Japanese children and required their students to read at least 40 of them as part of the grade in the course. The books were categorized into reading levels (color-coded for easy selection) according to length and complexity. Complete parts a through c. 14. A group of marketing professors asked every fourth adult entrant to a mall to participate in a study. A total of 119 shoppers agreed to answer the question, “Made locally” means what percentage of local labor and materials?” The responses of the 119 shoppers are summarized in the table to the right. Complete parts a through c below. 15. Graph the relative frequency histogram for the 300 measurements summarized in the relative frequency table to the right. 16. If jobs arrive at a particular work center at a faster rate than they depart, the work center impedes the overall production process and is referred to as a bottleneck. The data in the table were collected by an operations manager for use in investigating a potential bottleneck work center. 17. A data set contains the observations 3, 5, 4, 2, 3. Find the following values. 18. Calculate the mean and Median of the following grade point averages. 2.5 2.9 3.6 2.6 3.2 3.7 19. Five banks have been ranked by the amount charged to credit and debit cards issued by the banks. The table to the right gives the total amount charged in 2007 for the top ranked banks. 20. The data on the age (in years) of each of the 20 most powerful women in a region are shown below. 49 62 52 ……………………………………….64 21. The salaries of superstar professional athletes receive much attention in the media. The multimillion-dollar long-term contract is now commonplace among this elite group. Nevertheless, rarely does a season pass without negotiations between one or more of the players’ associations and team owners for additional salary and fringe benefits for all players in their particular sports. Complete parts a and b below. 22. Calculate the range, variance, and standard deviation for the following sample. 3, -3,2,……………….4 23. A university’s language professors incorporated a 10-week extensive redaing program into a second-semester Japanese language course in an effort to improve students’ Japanese reading comprehension. Fourteen students participated in this reading program. Complete parts a through c. 24. A country’s Energy Information Administration monitors all nuclear power plants operating in that country. The table to the right lists the number of active nuclear power plants operating in each of a sample of 10 states. 25. A study of 100,000 first-time candidates for the CPA exam found that the mean number of semester hours of college credit taken by the candidates was 144.58 hours. The standard deviation was reported to be 15.73 hours. Complete parts a through c. 26. Compute the z-score corresponding to each of the values of x below. 27. Compare the z-scores to decide which of the x values below lie the greatest above the mean and the greatest distance below the mean. 28. A sample data set has a mean of 74 and a standard deviation of 10. Determine whether each of the following sample measurements are outliers. 29. Consider the horizandal box shown to the right. 30. Educators are constantly evaluating the efficacy of public schools in the education and training of students. One quantitative assessment of change over time is the difference in scores on the SAT. The table below contains the average SAT scores for 10 states for the years 1988 and 2005. 31. Data on annual rainfall, maximum daily temperature, percentage of planet cover, and number of anti species recorded at each of 11 study sites are given in the accompanying table. Complete parts a through c. 32. Determine whether the random variable is discrete or continuous. 33. The random variable x has the following discrete probability distribution. Complete parts a through f. 34. X intercept, y intercept 35. If x is a binomial random variable, compute p(x) for each of the cases below. 36. According to a business magazine, 30% all small businesses owned by non-Hispanic whites nationwide are women-owned firms. 37. According to a certain golf association, the weight of the golf ball ball shall not be greater than 1.620 ounces (45.93 grams). The velocity of the ball shall not be greater than 250 feet per second. The golf association periodically checks the specifications of golf balls using sampling. Five dozen of each kind are sampled, and if more than three do not meet size or velocity requirements, that kind of ball is removed from the golf association’s approved list. Complete parts a and b. 38. Find the area under the standard normal probability distribution between the following pairs of z-scores. 39. Suppose the random variable x is the best described by a normal distribution with µ = 32 and = 5. Find the z-score that corresponds to each of the following x-values. 40. The mean gas mileage for a hybrid car is 56 miles per gallon. Suppose that the gasoline mileage is approximately normally distributed with a standard deviation of 3.2 miles per gallon. 41. Personnel tests are designed to test a job applicant’s cognitive and/or physical abilities. A particular dexterity test is administered nationwide by a private testing service. It is known that for all tests administered last year, the distribution of scores was approximately normal with mean 76 and standard deviation 7.8. 42. Determine evidence to support or contradict the assumption that the data to the right come from an approximately normal distribution. 43. An airport terminal handles an average of 3,000 international passengers an hour, but is capable of handling twice that number. Also after scanning all luggage, 20% arriving international passengers are detained for intrusive luggage inspection. The inspection facility can handle 500 passengers an hour without unreasonable delays for the travelers. Complete parts a through c. 44. Will the sampling distribution of always be approximately normally distributed? Explain. 45. The number of semester hours of college credit taken by first-time candidates for a certain professional exam has a distribution with a mean of 127 hours and a standard deviation of 14 hours. Consider a random sample of 100 first-time candidates for the exam and let represent the mean number of hours of college credit taken for the sample. Complete parts a through e below. =============================================== QNT 561 Week 1 Lab Work (New) For more course tutorials visit www.newtonhelp.com Chapter 2: Ex 4) Two Thousand three hundred frequent business travelers are asked which Midwestern city they prefer: Indianapolis, Saint Louis, Chicago or Milwaukee. 388 liked Indianapolis best, 450 liked Saint Louis, 1212 liked Chicago and the remainder prefers Milwaukee. Develop a frequency table and a relative frequency table to summarize this information (Round relative frequency to 3 decimal places.) Ex 6) A small business consultant is investigating the performance of several companies. The fourth-quarter sales for last year (in thousands of dollars) for the selected companies were: The consultant wants to include a chart in his report comparing the sales of six companies. Identify a bar chart that compares the fourth-quarter sales of these corporations. Ex 12) the quick change oil company has a number of outlets in the metropolitan Seattle area. The daily number of oil changes at the Oak Street outlet in the past 20 days is: a. How many classes would you recommend? d. Organize the number of oil changes into a frequency distribution. Ex 14) the food services division of Cedar River Amusement Park Inc, is studying the amount that families who visit the amusement park spend per day on food and drink. A sample of 40 families who visited the park yesterday revealed they spend the following amounts: a. Organize the data into a frequency distribution, using seven classes and 15 as the lower limit of the first class. What class interval did you select? b. Where do the data tend to cluster? Ex 18) Ecommerce.com, a large Internet retailer, is studying the lead time (elapsed time between when an order is placed and when it is filled) for a sample of recent orders. The lead time are reported in days. a. How many orders were studied? b. What is the midpoint of the first class? c. What are the coordinates of the first class for a frequency olygon assuming we draw a frequency polygon using the midpoints? Ex 20) The following cumulative frequency polygon shows the selling price ($000) of house sold in the Billings, Montana, area a. How many orders were studied? b. What is the class interval? c. One hundred homes sold for less than what amount? d. About 75% of the homes sold for less than what amount? e. Estimate the no of homes $150,000 up to $200,000 class. f. About how many homes sold for less than $225,000? =============================================== QNT 561 Week 2 Case Study MBA Schools in Asia Pacific (2 Papers) For more course tutorials visit www.newtonhelp.com Review the Case Study: MBA Schools in Asia-Pacific and the Case Study: MBA Schools in Asia-Pacific data set. Prepare a 1,050-word managerial report for your boss. Use the following questions for guidelines and directions on what to include in the report: 1. What is the type of data (Quantitative or Qualitative) for each of the columns (variables) in the dataset? If quantitative, is the data discrete or continuous? Neatly summarize your response in a table for all the columns (variables). 2. Using Excel, find the mean, median, standard deviation, minimum, maximum, and the three quartiles for each of the quantitative variables identified in part 1 above. Neatly summarize in a table on this document. Comment on what you observe. 3. What are the minimum and maximum full-time enrollments? Which schools have the minimum and maximum full-time enrollments? 4. What is the average number of students per faculty member? Is this low or high? What does this mean to prospective applicants who are interested in pursuing an MBA in one of the leading international business schools? 5. What are the mean, median, and modal ages? What does this mean to prospective applicants? 6. What is the mean percentage of foreign students? How many and which schools have 1% and 0% foreign students? Which schools have highest percentage of foreign students? Please state these percentages. 7. What percentage of schools require the GMAT test? 8. What percentage of schools require English tests such as Test of English as a Foreign Language (TOEFL)? 9. What percentage of schools require work experience? From this percentage, does this appear to be a significant factor in gaining admissions? 10. What are the mean and median starting salaries? Which schools have the minimum and maximum starting salaries? How much are these minimum and maximum salaries? 11. What are the mean tuition for foreign students and for local students? Does there appear to be a significant difference? What is the difference between the two means? 12. How many schools require work experience and how many of them don't? What is the mean starting salary for schools requiring work experience? What is the mean starting salary for schools requiring no work experience? 13. How many schools require English tests and how many don't? What is the mean starting salary for schools requiring English tests? What is the mean starting salary for schools requiring no English tests? 14. Does there appear to be a correlation between age and starting salaries? Comment on the strength and the direction of the correlation. 15. Comment on the skewness for the data on starting salaries: 1. Plot a histogram and determine the skewness. 2. Find the skewness coefficient. 3. Find the mean, median, and mode for starting salaries and compare the three measures to determine skewness. 16. Finally, use Empirical Rule on the starting salaries and determine whether the salaries follow the Empirical Rule. The pursuit of a higher education degree in business is now international. A survey shows more and more Asians choose the master of business administration (MBA) degree route to corporate success. As a result, the number of applicants for MBA courses at Asia-Pacific schools continues to increase. Across the region, thousands of Asians show an increasing willingness to temporarily shelve their careers and spend two years in pursuit of a theoretical business qualification. Courses in these schools are notoriously tough and include statistics, economics, banking, marketing, behavioral sciences, labor relations, decision making, strategic thinking, business law, and more. After your MBA, you get a job at Bloomberg in its media division, Bloomberg Business. Your division publishes reviews and rankings for business schools in the US and internationally. Because of your strong analytical education from University of Phoenix, your boss assigns you to work on preparing an analysis for data gathered for leading business schools in the Asia-Pacific. The data set in the Excel® file shows some of the characteristics of the leading Asia-Pacific business schools. =============================================== QNT 561 Week 2 DQ 1 For more course tutorials visit www.newtonhelp.com What are some examples of operational definitions in research design within your profession? For example, in the education field, graduation rate and retention rate are important operational definitions to measure progress of students. Likewise other professions have common metrics and definitions. Identify some metrics and operational definitions from your own career or a profession that you know well. Tell us why you think it is important! =============================================== QNT 561 Week 2 DQ 2 For more course tutorials visit www.newtonhelp.com What is the purpose of sampling? What are some concerns and dangers of sampling? How important is the sample design to data validity? Explain. Provide an example where a sample might misrepresent data validity. For example, reflect on the current political campaign and the pollsters! =============================================== QNT 561 Week 2 Individual My Statslab Problem Set For more course tutorials visit www.newtonhelp.com 1. A random sample of 87 observations produced a mean = 25.7 and a standard deviation s = 2.6. 2. Health care workers who use latex gloves with glove powder on a daily basis are particularly susceptible to developing a latex allergy. Each in a sample of 50 hospital employees who were diagnosed with a latex allergy based on a skin-prick test reported on their exposure to latex gloves. Summary statistics for thr number of latex gloves used per week are = 19.4 and s = 11.6. Complete parts (a) – (d). 3. Each child in a sample of 62 low-income children was administered a language and communication exam. The sentence complexity scores had a mean of 7.63 and a standard deviation of 8.92. Complete parts a through d. 4. The random sample shown below was selected from a normal distribution. 4, 10, 7,….2. Complete parts a and b. 5. Periodically, a town water department tests the drinking water of homeowners such as lead. The lead levels in water specimens collected for a sample of 10 residents of the town had a mean of 3.1 mg/L and a standard deviation of 1.2 mg/L. Complete parts a through c. 6. A random sample of size n = 250 yielded = 0.20. 7. A newspaper reported that 50% of people say that some coffee shops are overpriced. The source of this information was a telephone survey of 40 adults. 8. An accounting firm annually monitors a certain mailing service’s performance. One parameter of interest is the percentage of mail delivered on time. In a sample of 303,000 items mailed between Dec. 10 and Mar. 3__ the most difficult delivery season due to bad weather and holidays__ the accounting firm determined that 245,200 items were delivered on time. Use this information to make a statement about the likelihood of an item being on time by that mailing service. 9. Suppose oyu’re given a data set that classifies each sample unit into one of four categories: A, B, C, or D. You plan to create a computer database consisting of these data, and you decide to code the data as A = 1, B = 2, C = 3, and D = 4. Are the data consisting of the classifications A, B, C and D qualitative or Quantitative? After the data are input as 1, 2, 3, or 4, are they qualitative or Quantitative? 10. In one university, language professors incorporated a 10-week extensive program to improve students’ Japanese reading comprehension. The professors collected 262 books originally written for Japanese children and required their students to read at least 40 of them as part of the grade in the course. The books were categorized into reading levels (color-coded for easy selection) according to length and complexity. Complete parts a through c. 11. Use the relative frequency table shown to the right to calculate the number of the 400 measurements failing into each of the measurements classes. Then graph a frequency histogram for these data. 12. Five banks have been ranked by the amount charged to credit and debit cards issued by the banks. The table to the right gives the total amount charged in 2007 for the top ranked banks. 13. Compare the z-scores to decide which of the x values below lie the greatest above the mean and the greatest distance below the mean. 14. Consider the horizandal box plot shown to the right. 15. Educators are constantly eveluating the efficacy of public schools in the education and training of tudents. One quantitative assessment of change over time is the difference in scores on the SAT. The table below contains the average SAT scores for 10 states for the years 1988 and 2005. 16. The mean gas mileage for a hybrid car is 56 miles per gallon. Suppose that the gasoline mileage is approximately normally distributed with a standard deviation of 3.2 miles per gallon. =============================================== QNT 561 Week 2 Lab Work (New) For more course tutorials visit www.newtonhelp.com Chapter 5: Ex 4) A large company must hire a new president. The Board of Directors prepares a list of five candidates, all of whom are equally qualified. Two of these candidates are members of a minority group. To avoid bias in the selection of the candidate, the company decides to select the president by lottery. a. What is the probability one of the minority candidate is hired? b. Which concept of probability did you use to make this estimate? Ex 14) The chair of the board of directors says, “ There is a 50% chance this company will earn a profit, a 30% chance it will break even, and a 20% chance it will lose money next quarter”: a. Use an addition rule to find the probability the company will not lose money next quarter b. Use the complement rule to find the probability it will not lose money next quarter. EX 22 ) A National Park Service survey of visitors to the Rocky Mountain region revealed that 50% visit Yellowstone park, 40% visit the Tetons, and 35% visit both. a) What is the probability a vacationer will visit at least one of these attractions? b) What is the probability .35 called? c) Are the events mutually exclusive? Ex 40) Value : 10.00 Points Solve the following: a) 20!/17! b) 9P3 c) 7C2 Ex 34) Use Bayes’ theorem to determine P(A3| B1) Chapter 6: Ex 4) Which of these variables are discrete and which are continuous random variables? a. The number of new accounts established by a salesperson b. The time between customer arrivals to a bank ATM c. The number of customers in Big Nick’s barber shop d. The amount of fuel in your car’s gas tank EX. 14) The U.S postal service reports 95% of first-class mail within the same city is delivered within 2 days of the time of mailing. Six letters are randomly sent to different locations. a) What is the probability that all six arrive within 2 days? b) What is the probability that will arrive within 2 days. c) Compute the variance of the number that will arrive within 2 days. d) Compute the standard deviation of the number that will arrive within 2 days. Ex 20) Binomial Distribution EX. 26) A Population consists of 15 items, 10 of which are acceptable. In a sample of four items, what is the probability that exactly three are acceptable? Assume the samples are drawn without replacement. Chapter 7: Ex 4) According to the insurance institute of America, a family of four spends between $400 and $3,800 per year on all type of insurance. Suppose the money spent is uniformly distributed between these amounts. a. What is the mean amount spent on insurance? b. What is S.D of the amount spent? c. If we select a family at random, What is the probability they spend less than $2,000 per year on insurance per year? d. What is the probability a family spends more than $3,000 per year? EX.10)The mean of a normal probability distribution is 60; the standard deviation is 5. a) About what percent of the observations lie between 55 and 65? b) About what percent of the observations lie between 50 and 70? c) About what percent of the observations lie between 45 and 75? Ex 14) A normal population has a mean of 12.2 and a standard deviation of 2.5 a. Complete the z value associated with 14.3 b. What proportion of the population is between 12.2 and 14.3? c. What proportion of the population less than 10? Ex 18) A normal population has a mean of 80.0 and a standard deviation of 14.0 a. Compute the probability of a value between 75.0 and 9.0 b. Compute the probability of a value of 75.0 or less c. Compute the probability of a value between 55.0 and 70.0 EX. 28) For the most recent year available, the mean annual cost to attend a private university in the united States was $26,889. Assume the distribution of annual costs follows the normal probability distribution and the standard deviation is $4,500. Ninety-five percent of all students at private universities pay less than what amount? =============================================== QNT 561 Week 2 Team Assignment Business Research Project Part 1 Business Problem and Research Questions For more course tutorials visit www.newtonhelp.com Identify an organization or business for your Learning Team research project. Describe the products or services it provides. Identify a problem or dilemma faced by the organization that could be addressed by research. Discuss the problem as a team. Discuss your selected problem or dilemma with your faculty member to ensure that it is at an appropriate scope for the course. Develop a purpose statement for your research project. Create a draft of the research questions addressing the problem and purpose statements. Format your paper consistent with APA guidelines. Click the Assignment Files tab to submit your assignment. =============================================== QNT 561 Week 2 Team Assignment Business Research Project Part 1 Formulation of the Research Problem For more course tutorials visit www.newtonhelp.com Identify an organization from any member in your Learning Team or an organization with which your team is familiar. If an actual company is used, disguise its name with a pseudonym. Identify one independent variable and one dependent variable based on the business. Operationalize these variables if they are too abstract to measure. Develop a real or realistic research question for the company you chose and the two variables. Include a background, a business problem and the team's role of no more than 500 words. Develop a research question from the two variables. Keep you research question simple, easy to understand and able to be quantified with research data. Use the Research Question Two Variable Handout for guidance. Create hypothesis statements based on the research question. Format your paper consistent with APA guidelines. Click the Assignment Files tab to submit your assignment. =============================================== QNT 561 Week 3 Assignment Expansion Strategy and Establishing a Re-Order Point For more course tutorials visit www.newtonhelp.com Learning team paper Purpose of Assignment This assignment has two cases. The first case is on expansion strategy. Managers constantly have to make decisions under uncertainty. This assignment gives students an opportunity to use the mean and standard deviation of probability distributions to make a decision on expansion strategy. The second case is on determining at which point a manager should re-order a printer so he or she doesn't run out-of-stock. The second case uses normal distribution. The first case demonstrates application of statistics in finance and the second case demonstrates application of statistics in operations management. Assignment Steps Resources: Microsoft Excel®, Bell Computer Company Forecasts data set, Case Study Scenarios Write a 1,050-word report based on the Bell Computer Company Forecasts data set and Case Study Scenarios. Include answers to the following: Case 1: Bell Computer Company Compute the expected value for the profit associated with the two expansion alternatives. Which decision is preferred for the objective of maximizing the expected profit? Compute the variation for the profit associated with the two expansion alternatives. Which decision is preferred for the objective of minimizing the risk or uncertainty? Case 2: Kyle Bits and Bytes What should be the re-order point? How many HP laser printers should he have in stock when he re-orders from the manufacturer? Format your assignment consistent with APA format. =============================================== QNT 561 Week 3 Case Study SuperFun Toys (2 Papers) For more course tutorials visit www.newtonhelp.com Individual Paper: Purpose of Assignment The purpose of this assignment is for students to learn how to make managerial decisions using a case study on Normal Distribution. This case uses concepts from Weeks 1 and 2. It provides students an opportunity to perform sensitivity analysis and make a decision while providing their own rationale. This assignment also shows students that statistics is rarely used by itself. It shows tight integration of statistics with product management. Assignment Steps Develop a 1,050-word case study analysis including the following: • Use the sales forecaster’s prediction to describe a normal probability distribution that can be used to approximate the demand distribution. • Sketch the distribution and show its mean and standard deviation. Hint: To find the standard deviation, think Empirical Rule covered in Week 1. • Compute the probability of a stock-out for the order quantities suggested by members of the management team (i.e. 15,000; 18,000; 24,000; 28,000). • Compute the projected profit for the order quantities suggested by the management team under three scenarios: pessimistic in which sales are 10,000 units, most likely case in which sales are 20,000 units, and optimistic in which sales are 30,000 units. One of SuperFun’s managers felt the profit potential was so great the order quantity should have a 70% chance of meeting demand and only a 30% chance of any stock- outs. What quantity would be ordered under this policy, and what is the projected profit under the three sales scenarios? SuperFun Toys, Inc., sells a variety of new and innovative children’s toys. Management learned the pre-holiday season is the best time to introduce a new toy because many families use this time to look for new ideas for December holiday gifts. When SuperFun discovers a new toy with good market potential, it chooses an October market entry date. To get toys in its stores by October, SuperFun places one-time orders with its manufacturers in June or July of each year. Demand for children’s toys can be highly volatile. If a new toy catches on, a sense of shortage in the marketplace often increases the demand to high levels and large profits can be realized. However, new toys can also flop, leaving SuperFun stuck with high levels of inventory that must be sold at reduced prices. The most important question the company faces is deciding how many units of a new toy should be purchased to meet anticipated sales demand. If too few are purchased, sales will be lost; if too many are purchased, profits will be reduced because of low prices realized in clearance sales. This is where SuperFun feels that you, as an MBA student, can bring value. For the coming season, SuperFun plans to introduce a new product called Weather Teddy. This variation of a talking teddy bear is made by a company in Taiwan. When a child presses Teddy’s hand, the bear begins to talk. A built-in barometer selects one of five responses predicting the weather conditions. The responses range from “It looks to be a very nice day! Have fun” to “I think it may rain today. Don’t forget your umbrella.” Tests with the product show even though it is not a perfect weather predictor, its predictions are surprisingly good. Several of SuperFun’s managers claimed Teddy gave predictions of the weather that were as good as many local television weather forecasters. As with other products, SuperFun faces the decision of how many Weather Teddy units to order for the coming holiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or 28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning the market potential. Having a sound background in statistics and business, you are required to perform statistical analysis and the profit projections which is typically done by the product management group. You want to provide management with an analysis of the stock-out probabilities for various order quantities, an estimate of the profit potential, and to help make an order quantity recommendation. SuperFun expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains after the holiday season, SuperFun will sell all surplus inventories for $5 per unit. After reviewing the sales history of similar products, SuperFun’s senior sales forecaster predicted an expected demand of 20,000 units with a 95% probability that demand would be between 10,000 units and 30,000 units. One of SuperFun's managers felt the profit potential was so great the order quantity should have a 70% chance of meeting demand and only a 30% chance of any stock- outs. What quantity would be ordered under this policy, and what is the projected profit under the three sales scenarios? =============================================== QNT 561 Week 3 DQ 1 For more course tutorials visit www.newtonhelp.com In your organization’s management development program, there was a heated discussion between people who claimed that theory is impractical and not effective, and others who claimed that effective theory is the most practical approach to problems. What position would you take and why? =============================================== QNT 561 Week 3 DQ 2 For more course tutorials visit www.newtonhelp.com You observe female sales representatives having lower customer defections than male sales representatives. What concepts and constructs would you use to study this phenomenon? How might the concepts or constructs relate to explanatory hypotheses? Explain. =============================================== QNT 561 Week 3 Individual Mystatslab Problem Set For more course tutorials visit www.newtonhelp.com 1. Which hypothesis, the null or the alternative, is the status-quo hypothesis? 2. A university economist conducted a study of elementary school lunch menus. During the state-mandated testing period, school lunches averaged 890 calories. The economist claimed that after the testing period ended, the average caloric content of the school lunches increased/dropped significantly. Set up the null and alternative hypothesis to test the economist’s claim. 3. Suppose the mean GPA of all students graduating from a particular university in 1975 was 2.40. The register plans to look at records of graduating last year to see if the mean GPA has decreased. Define notation and state the null and alternative hypothesis for this investigation. 4. A random sample of 100 observations from a population with standard deviation 58 yielded a sample mean of 111. Complete parts a through c. 5. A final scores of games of a certain sport were compared against the final point spreads established by oddsmakers. The difference between the game outcome and point spread (called a point-spread error) was calculated for 250 games. The mean and standard deviation of the point-spread errors are = 1.7 and s = 13.1. Use this information to test the hypothesis that the true mean point-spread error for all games differs from 0. Conduct the test at α = 0.10 and interpret the result. 6. If a hypothesis test were conducted using α = 0.025, for which of the following p-values would the null hypothesis be rejected? 7. For the α and observed significance level (p-value) pair, indicate whether the null hypothesis would be rejected. α = 0.10, p-value = 0.001 8. In a test of the hypothesis H0:µ = 40 versus Ha: µ ≠ 40, a sample of n = 50 observations possessed mean = 40.7 and standard deviation s = 3.8. Find the p-value for this test. 9. In a study it was found that the averge age of cable TV shoppers was 55 years. Suppose you want to test the null hypothesis, H0:µ = 55, using a sample of n = 60 cable TV shoppers. 10. A sample of seven mesurements, randomly selected from a normally distributed population, resulted in the summary statistics = 4.6 and s = 1.2. Complete parts athrough c. 11. A study analysis recent incidents involving terrorist attacks. Data on the number of individual suicide bombings that occurred in each of 20 sampled terrorist group attcks against a country is reproduced in the data table below. An Excel/DDXL printout is shown to the right. Complete parts a through e. 12. When planning for a new forest road to be used for tree harvesting, planners must select the location to minimize tractor skidding distance. The skidding distances (in meters) were measured at 20 randomly selected road sites. The data are given below. A logger working on the road claims the mean skidding distance is atleast 424 meters. Is there sufficient evidence to refute this claim? Use α = 0.10 / α = 0.01. 13. For the binomial sample sizes and null hypothesized values of p in each part, determine whether the sample size is large enough to meet the required conditions for using the normal approximation to conduct a valid large-sample hypothesis test of the null hypothesis H0: p = p0. Complete parts a through e. 14. Suppose a consumer group rated 49 brands of toothpaste based on whether or not the brand carries an American Dental Association (ADA) seal verifying effective decay prevention. The results of a hypothesis test for the proportion of brands with the seal are shown to the right. Complete parts a through c. 15. In order to compare the means of two populations, independent random samples of 410 observations are selected from each population, with the results found in the table to the right. Complete parts a through e. 16. To use the t-statistic to test for a difference between the means of two populations, what assumptions must be made about the two populations? About the two samples? 17. 18. Independent random samples are selected from two populations and are used to test the hypothesis H0: (µ1 - µ2) = 0 against the alternative Ha: (µ1 - µ2) ≠ 0. An analysis of 234 observations from population 1 and 310 from population 2 yielded a p-value of 0.113. Complete parts a and b below. 19. A study was done to examine whether the perception of service quality at hotels differd by gender. Hotel guests were randomly selected to rate service items on a 5-point scale. The sum of the items for each guest was determined and a summary of the guest scores are provided in the table. Complete parts a and b. 20. To determine if winning a certain award leads to a challenge in life expectancy, researches sampled 748 award winners and matched each one with another person of the same sex who was in the same profession and was born in the same era. The lifespan of each pair was compared. Complete parts a through c below. 21. A new testing method was developed to reduce a certain ratio. The data in the table show the ratios that resulted from testing six components using the standard method and the new method. Compare the two methods with a 90% confidence interval. Which method has the smaller mean ratio? 22. Consider making an interference about p1 – p2 , where there are x1 successes in n1 binomial trails and x2 succeseses in n2 binomial trails. 23. Construct a 90% confidence interval for (p1 – p2) in each of the following situations. 24. In auction bidding the “winner’s curse” is the phenomenon of the winning (or highest) bid price being above the expected value of the item being auctioned. A study was conducted to see if less-experienced bidders were more likely to be impacted by the curse than super-experienced biders. The study showed that of the 180 bids by super-experienced bidders, 26 winning bids were above the item’s expected value, and of the bids by the 140 less-experienced bidders, 31 winning bids were above the item’s expected value. Complete parts athrough d. 25. School buying is a form of aggressive behavior that occurs when a student is exposed repeatedly to negative actions from another student. In order to study the effectivenss of an antibullying policy at elementary schools, a survey of over 2,000 elementary school children was conducted. Each student was asked if he or she ever bullied another student. In a sample of 1358 boys, 745 Claimed th

487 views • 44 slides