Instruction for lab work: • Students have to attempt any I question from Section-A & B Students have to write the step-b

[answerhappygod]

Instruction For Lab Work Students Have To Attempt Any I Question From Section A B Students Have To Write The Step B 1 (65.43 KiB) Viewed 38 times

Instruction For Lab Work Students Have To Attempt Any I Question From Section A B Students Have To Write The Step B 2 (49.28 KiB) Viewed 38 times

Instruction for lab work: • Students have to attempt any I question from Section-A & B Students have to write the step-by-step commands to solve each problem as well as screenshots at each step. * Section -A Use Excel (Solve any 1 question 1. For the following random numbers 0.488 0.226 0.221 0.043 0.055 0.743 0.081 0.685 0.364 0.012 0.372 0.543 0.483 0.050 0.628 0.966 0.750 0.697 0.764 0.040 0.404 0.549 0.203 0.990 0.155 0.079 0.789 0.462 0.795 0.190 Perform chi-square test in Excel, test the following hypothesis taking a -0.05: HR-U[0,1] H: R-/U[0,1] 2. Perform Kolmogorov - Smimov test in Excel to test the hypothesis for the following random number: 0.136 0.513 0.844 0.681 0.154 0.239 0.888 0.090 0.631 0.245 0.394 0.531 0.715 0.276 0.880 Determine whether the Hypothesis of uniformity can be rejected, given a=0.05 and critical value of D = 0.338 and 3. With the given mean and standard deviation simulate values for that normal distribution Using the excel formula NORMINV(Rand(), mean, sd). This is applicable for X,Y& Z thus the W value can also be simulated (w =(x+y) z). Prepare the simulation of 25 values and the histogram with width 3 class interval. 4. A taxicab company operates one vehicle during the 9:00 A.M. to 5:00 P.M. period. The demand for taxi follows the distribution shown: 35 30 25 2015 Time between Calls (Minutes) 0.04||0.17 0.43 0.22 0.14 Probability The distribution of time to complete a service is as follows: 45 35 25 0.04 0.06 0.43 15 15 Service Time (Minute) 0.35 0.12 Probability Using EXCEL simulate for 100 customers, calculate waiting times of the customers.

5. A classical inventory problem concerns the purchase and sale of newspapers. The paper seller buys the papers for 1.50 cents each and sells them for 2 Riyals cach. Newspapers not sold at the end of the day are sold as scrap or 20 Halalas cach. Newspapers can be purchased in bundles of 10 Thus, the paper seller can buy 50, 60, and so on. There are three types of Newsday's, good, fair, and poor with probabilities of 0.30, 0.45, and 0.25 respectively. The distribution of papers demanded on each of these days is given in table The problem is to determine the total profit. This will be accomplished by simulating demands for 30 days and recording profits from sales each day. The distribution of demand for newspapers by type today is given in the following table: Demand Demand Probability Distribution Good Fair Poor 40 0.02 0.12 033 50 0.06 0.16 0.26 60 0.20 0.35 0.18 70 0.15 0.25 0.15 80 0.18 0.08 0.08 90 0.32 0,04 0.00 100 0.00 0.00 0.07 Determine the optimal number of newspapers that a newspaper seller buys daily in order to achieve the the highest profit. Simulate 30 days using EXCEL to find out what is required of whether the seller buys 80,70,60,50 newspapers per day. Note: Profits are calculated from the formula P-R-C-LS Where the symbols mean: (Profits) P-Profit (Total Sales Amount) R Revenue from sales (Cost of newspapers) C-Cost of newspapers (Lost Profits from Not Fulfilling Order) (Refunded Amount from Selling Remaining Newspapers) L-Lost profit from excess demand S = salvage from sale of scrap papers • Section - B Use Scilab Solve any question 1. Write a code to Create a vector of the even whole numbers between 1 and 200. 2. Write a code to draw a Parabola in Scilab where y-mx 8+c 3. Plot the expression Pl) - 8219289171/(1+0-0.0312(t-1919), where t is the date. Using t - 2022 to 2025 Create a Sin plot y=sin 2x.04-Api,taking 250 linearly points in the given Interval. Label the axis and put the plot created with your name'. Estimation of Pi using Monte Carlo Method Sci Code where n-2000 5.