HI I actually have a couple documents/ questions from excel that I'll be attaching separately. I saw that you've been able to do these.

The Air Force Museum Foundation has commissioned the purchase of 16 Four F Sixes, pre-World War II aircraft. scratch to the exact specifications used for the originals. As further authentication, the aircraft will be made using processes available when the originals were built. Each of the 16 will be flown to Air Force and aviation museum Aviation enthusiasts can also visit the production facility to see exactly how such aircraft were built in 1938. Soren Industries wants to bid on the aircraft contract and asked for and received certain cost information about t information includes some of the old cost data from the builders of the original aircraft. The available information one, eight, thirty one and sixty five aircraft, respectively, were completed. Output 1 8 31 65 Total Hours Required 1. Graphically determine the learning curve. 237 1,321 4,584 7,753 2. What are the following learning curve parameters: Y=aX^b a b R square Learning curve percentage Hours Per Unit 237.00 165.13 147.87 119.28 3. If Soren Industries expects that the manufacturing time will be the same as it was in 1938, how many hours wi Air Force Museum Foundation? Units Hours to make 4. Algebraically determine the learning curve. Transform Y & X Hours Per Output Unit Linear regression of transformed data a b R square Learning curve percentage e-World War II aircraft. They will be built completely from rcraft will be made using the technology and manufacturing e and aviation museums throughout the country for exhibition. were built in 1938. cost information about the Four F Sixes from the Air Force. The The available information is for the total accumulated time for 938, how many hours will it take to build the 16 aircraft for the Excel Instructions Chart(s) - charts have many properties, you will set only the following properties. Name ChartType Location ChartWidth ChartHeight Series Name XValues Values PlotOrder Format.Line/Border.ForeColor Format.Fill.ForeColor Format.Line.Width ChartTitle Caption Font.Name Font.Size Font.Bold ChartLegend Position Font.Name Font.Size Font.Bold Axis - Horizontal AxisTitle AxisTickLabelsFormat Axis - Vertical AxisTitle AxisTickLabelsFormat ChartAreaColor PlotAreaColor Chart # 1 Chart 1 Scatter $B$12 6 4 Series 1 Series1 $C$6:$C$9 $G$6:$G$9 Not this semester Red 255, Green 255, Blue 255 N/A N/A Learning Curve Calibri 14 True No chart legend Output #,##0;[Red]#,##0 Hours Per Unit #,##0.00;[Red]#,##0.00 Red 235, Green 241, Blue 222 Red 217, Green 217, Blue 217 Chart # 2 Chart 2 Scatter $H$49 6 4 Series 1 Series1 $C$49:$C$52 $E$49:$E$52 Not this semester Red 255, Green 255, Blue 255 N/A N/A Transformed Learning Curve Calibri 14 True No chart legend Output 0.0000 Hours Per Unit 0.0000 Red 253, Green 234, Blue 218 Red 219, Green 238, Blue 244 The Air Force Museum Foundation has commissioned the purchase of 16 Four F Sixes, pre-World War II aircraft. specifications used for the originals. As further authentication, the aircraft will be made using the technology and built. Each of the 16 will be flown to Air Force and aviation museums throughout the country for exhibition. Aviati exactly how such aircraft were built in 1938. Soren Industries wants to bid on the aircraft contract and asked for and received certain cost information about t some of the old cost data from the builders of the original aircraft. The available information is for the total accum respectively, were completed. Output Hours Per Unit Total Hours 1 8 31 65 237 1,321 4,584 7,753 Required 1. Graphically determine the learning curve. 237.00 165.13 0.69672996 147.87 119.28 1,084 135.5 0.57172996 143.25 0.60443038 Learning Curve 250.00 1 f(x) = 235.6318663013 x^-0.1544756795 R = 0.973003494 200.00 2 150.00 3 Output 4 100.00 50.00 0.00 0 10 20 30 40 Hours Per Unit 2. What are the following learning curve parameters: Y=aX^b a b R square Learning curve percentage 235.6300 -0.1540 0.9730 86% 50 60 70 3. If Soren Industries expects that the manufacturing time will be the same as it was in 1938, how many hours wi Foundation? Units Hours to make 16 1,188 4. Algebraically determine the learning curve. Transform Y & X Output 1.0000 8.0000 31.0000 65.0000 Hours Per Unit 237.0000 165.1250 147.8710 119.2769 Linear regression of transformed data -0.4868 -1.4725 -1.2378 -0.8071 -1.1891 -0.8410 0.0000 0.0000 a b R square Learning curve percentage 0.2294 -0.4868 -1.1891 61% World War II aircraft. They will be built completely from scratch to the exact ng the technology and manufacturing processes available when the originals were ry for exhibition. Aviation enthusiasts can also visit the production facility to see st information about the Four F Sixes from the Air Force. The information includes n is for the total accumulated time for one, eight, thirty one and sixty five aircraft, 1,896.0 0.697 8, how many hours will it take to build the 16 aircraft for the Air Force Museum Excel Instructions Chart(s) - charts have many properties, you will set only the following properties. Name ChartType Location ChartWidth ChartHeight Series Name XValues Values PlotOrder Format.Line/Border.ForeColor Format.Fill.ForeColor Format.Line.Width ChartTitle Caption Font.Name Font.Size Font.Bold ChartLegend Position Font.Name Font.Size Font.Bold Axis - Horizontal AxisTitle AxisTickLabelsFormat Axis - Vertical AxisTitle AxisTickLabelsFormat ChartAreaColor PlotAreaColor Chart # 1 Chart 1 Scatter $B$12 6 4 Series 1 Series1 $C$6:$C$9 $G$6:$G$9 Not this semester Red 255, Green 255, Blue 255 N/A N/A Learning Curve Calibri 14 True No chart legend Output #,##0;[Red]#,##0 Hours Per Unit #,##0.00;[Red]#,##0.00 Red 235, Green 241, Blue 222 Red 217, Green 217, Blue 217 Chart # 2 Chart 2 Scatter $H$49 6 4 Series 1 Series1 $C$49:$C$52 $E$49:$E$52 Not this semester Red 255, Green 255, Blue 255 N/A N/A Transformed Learning Curve Calibri 14 True No chart legend Output 0.0000 Hours Per Unit 0.0000 Red 253, Green 234, Blue 218 Red 219, Green 238, Blue 244 The Air Force Museum Foundation has commissioned the purchase of 16 Four F Sixes, pre-World War II aircraft. specifications used for the originals. As further authentication, the aircraft will be made using the technology and built. Each of the 16 will be flown to Air Force and aviation museums throughout the country for exhibition. Aviati exactly how such aircraft were built in 1938. Soren Industries wants to bid on the aircraft contract and asked for and received certain cost information about t some of the old cost data from the builders of the original aircraft. The available information is for the total accum respectively, were completed. Output Hours Per Unit Total Hours 1 8 31 65 237 1,321 4,584 7,753 Required 1. Graphically determine the learning curve. 237.00 165.13 147.87 119.28 Learning Curve 250.00 1 f(x) = 235.6318663013 x^-0.1544756795 R = 0.973003494 200.00 2 150.00 3 Output 4 100.00 50.00 0.00 0 10 20 30 Hours Per Unit 2. What are the following learning curve parameters: Y=aX^b a b R square Learning curve percentage 235.6300 -0.1540 0.9730 86% 40 50 60 70 3. If Soren Industries expects that the manufacturing time will be the same as it was in 1938, how many hours wi Foundation? Units Hours to make 16 1,188 4. Algebraically determine the learning curve. Transform Y & X Output 1.0000 2.0794 3.4340 4.1744 Hours Per Unit 5.4681 5.1067 4.9963 4.7814 5.6000 5 5.4000 Linear regression of transformed data -4.7617 -0.1967 -6.0310 -0.1462 -3.4454 -0.2902 0.0000 0.0000 a b R square Learning curve percentage 5.2000 Output 5.0000 4.8000 5.4620 -0.0860 0.9565 92% 4.6000 4.4000 0.5000 1.000 World War II aircraft. They will be built completely from scratch to the exact ng the technology and manufacturing processes available when the originals were ry for exhibition. Aviation enthusiasts can also visit the production facility to see st information about the Four F Sixes from the Air Force. The information includes n is for the total accumulated time for one, eight, thirty one and sixty five aircraft, 4 70 8, how many hours will it take to build the 16 aircraft for the Air Force Museum Learning Curve 5.6000 5.4000 5.4681 f(x) = 5.4662021221 x^-0.0858401922 R = 0.9564693259 5.2000 5.1067 utput 5.0000 4.9963 4.8000 4.7814 4.6000 4.4000 0.5000 1.0000 1.5000 2.0000 2.5000 Hours Per Unit 3.0000 3.5000 4.0000 4.5000 Excel Instructions Chart(s) - charts have many properties, you will set only the following properties. Name ChartType Location ChartWidth ChartHeight Series Name XValues Values PlotOrder Format.Line/Border.ForeColor Format.Fill.ForeColor Format.Line.Width ChartTitle Caption Font.Name Font.Size Font.Bold ChartLegend Position Font.Name Font.Size Font.Bold Axis - Horizontal AxisTitle AxisTickLabelsFormat Axis - Vertical AxisTitle AxisTickLabelsFormat ChartAreaColor PlotAreaColor Chart # 1 Chart 1 Scatter $B$12 6 4 Series 1 Series1 $C$6:$C$9 $G$6:$G$9 Not this semester Red 255, Green 255, Blue 255 N/A N/A Learning Curve Calibri 14 True No chart legend Output #,##0;[Red]#,##0 Hours Per Unit #,##0.00;[Red]#,##0.00 Red 235, Green 241, Blue 222 Red 217, Green 217, Blue 217 Chart # 2 Chart 2 Scatter $H$49 6 4 Series 1 Series1 $C$49:$C$52 $E$49:$E$52 Not this semester Red 255, Green 255, Blue 255 N/A N/A Transformed Learning Curve Calibri 14 True No chart legend Output 0.0000 Hours Per Unit 0.0000 Red 253, Green 234, Blue 218 Red 219, Green 238, Blue 244