The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contentsĬreate a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip. The following program contains five errors. This program will have two classes, a LineItem class and a Transaction classĭevelop a program to emulate a purchase transaction at a retail store. Develop a program to emulate a purchase transaction at a retail store. To find standard deviation of a population, use the STDEV.P function in Excel 2010 and later STDEVP in Excel 2007 and earlier. Overview: For this assignment, you will implement the fundamental operations of create, read, update. The fundamental operations of create, read, update, and delete (CRUD) in either Python or JavaĬS 340 Milestone One Guidelines and Rubric 3 Using Excel, evaluate the standard deviation of this new data set. Ex.1 Using Excel, find the mean of this data set. If your data set is a sample of a population, (rather than an entire population), you should use the slightly modified form of the Standard Deviation, known as the Sample Standard Deviation. Click on cell F13 and type =STDEV(B5:B9). where x takes on each value in the set, x is the average (statistical mean) of the set of values, and n is the number of values in the set. If you do not need the table and all you need is SD you may get it directly. The command in Excel for the square root is SQRT click on cell E13 and type =sqrt(E12) There is also a short cut to get standard deviation in Excel. To get SD we take the square root of variance. Click on cell E11 and type =sum(E5:E9) click on cell E12 and type =E11/4 We got the variance. Click on cell D12 and type VARIANCE click on cell D13 and type SD Now do not average since we have a sample and we are not dividing by 5 but by one less. The final column is square deviations so click on cell E4 and type SID click on cell E5 type = then click on cell D5 and then type ^2 click on cell E6 type = then click on cell D6 and then type ^2 click on cell E7 type = then click on cell D7 and then type ^2 click on cell E8 type = then click on cell D8 and then type ^2 click on cell E9 type = then click on cell D9 and then type ^2 We are ready to compute the variance and the SD now. Click on cell D9 type = then click on cell B9 type -, and then click on C9. Click on cell D8 type = then click on cell B8 type -, and then click on C8. Click on cell D7 type = then click on cell B7 type - and then click on C7. Click on cell D6 type = then click on cell B6, type -, and then click on C6. Click on cell C5 and type = and then click on cell B11 click on cell C6 and type = and then click on cell B11 click on cell C7 and type = and then click on cell B11 click on cell C8 and type = and then click on cell B11 click on cell C9 and type = and then click on cell B11 Next column is deviations so click on cell D4 and type ID click on cell D5 type = then click on cell B5, type -, and then click on C5. Click on cell B11 and =average(then highlight the data from B5 to B9 and then press enter click on cell C4 and type MEAN. The second column is the mean, so we have to evaluate mean. In cell B4 type AGES click on cell B5 and type 23 click on cell B6 and type 20 click on cell B7 and type 22 click on cell B8 and type 24 click on cell B9 and type 26 Now we have the first column. Lets use Excel to find the mean and the standard deviation. We take a sample of five students and obtain the following data 23 20 22 24 26. Open the Excel program Suppose we want to know the average age of college students.Excel use Excel to find the mean and the standard deviation INSTRUCTIONS TO CANDIDATES ANSWER ALL QUESTIONS
0 Comments
Leave a Reply. |
AuthorAllison ArchivesCategories |