Essay About Ceo Of Solar Solutions Inc And Statistical Analysis

Case -2
Case -2
MemorandumFrom:  To: Bill Owen, CEO of Solar Solutions Inc, CaliforniaDate: RE:  Statistical analysis for solar installationDear Bill, This is to bring your kind attention to our recent statistical study to determine how much solar panel can be reduced energy consumption in a typical middle class home. We have found out from our study that there is potential energy savings from solar power. After the solar panels were installed, the gas consumption had been reduced. Please find below our findings and conclusions on this based on the statistical data which is pictorially represented in the appendix.Conclusion:There is a very strong, negative, and linear correlation between gas consumption and outside temperature.After solar panels installation there is a change in R2 value, from 99.1% to 98.2%, this shows that solar panels installation affects the gas consumption.The amount of gas used is decreased after solar panels installationGas saving in $ ➔ Gas used is reduced by 217.3 feet3 or 16.255 gallons after solar panels installation. Assume that the cost of gas is $3.45/gallon, thus $56.07 can be saved by installing solar panels.[pic 1]Figure 1. Scatterplot before installation for solar[pic 2]Y = 13.37 – (0.188) X[pic 3]Figure 2. Scatterplot after installation for solar[pic 4]Y = 11.05 – (0.016) X[pic 5]Figure 3. Boxplot of Degree days (DD)[pic 6][pic 7][pic 8]Figure 4. Boxplot of gas used (GU)[pic 9][pic 10][pic 11]Figure 5. Histogram of degree days before installation[pic 12][pic 13]Figure 6. Histogram of gas used before installation[pic 14][pic 15]Figure 7. Histogram of degree days after installation[pic 16][pic 17]Figure 8. Histogram of gas used after installation[pic 18]